{ "generated_on": "2026-07-31", "count": 27, "seeds": [ { "idea_number": 1, "slug": "used-aircraft-price-index", "idea": "Used Aircraft Price Index", "worker_url": "https://sprinkle-pr-data-seeds.alexdunsdonagent.workers.dev/jobs/1", "seed_status": "current benchmark live — weekly; index history collecting", "generated_on": "2026-07-31", "current_record_summary": "17 reportable segments from 1,051 clean classified listings; 22 price records held for review", "current_metrics": { "dealer_listings": { "total_rows": 13904, "active_rows": 6801, "active_priced_rows": 2033, "latest_active_posted_at": "2026-06-01T15:46:08.701+00:00", "active_priced_currencies": 5, "earliest_active_posted_at": "2025-10-10T15:02:52.208+00:00" }, "portal_listings": { "sold_rows": 6, "total_rows": 51, "active_rows": 35, "active_priced_rows": 23 }, "listing_metrics": { "snapshot_rows": 19, "latest_snapshot_date": "2026-07-31", "earliest_snapshot_date": "2026-07-03" }, "job_1_output": { "generated_on": "2026-07-30", "fx_date": "2026-07-29", "reporting_currency": "GBP", "reportable_segments": 17, "clean_classified_listings": 1051, "source_listings": 2056, "classified_source_listings": 1061, "price_records_held_for_review": 22, "currencies": [ "AUD", "CAD", "EUR", "GBP", "USD" ], "methodology": "Current active asking prices converted to GBP using the published ECB daily reference rates. Records carrying the Worker's price-review flag and unclassified models are excluded; segments require at least five clean listings.", "caveat": "This is a current asking-price benchmark, not a completed-sale series or historical price index." } }, "source_tables": [ "_gdb_dealer_listing", "_gdb_model", "_gdb_family", "_gdb_category", "_gdb_manufacturer", "_gdb_mkt_aircraft_listing", "_gdb_mkt_listing_metrics_daily" ], "requested_fields": "Listing ID; aircraft segment; asking price; currency; first-seen date; active/sold status", "still_missing": "The current asking-price benchmark is live. A historical price index still requires 12 comparable monthly snapshots and better completed-sale evidence.", "collection_plan": "Save one dated copy of every active priced listing; convert prices to one currency; calculate medians by segment", "frequency": "Weekly snapshot; monthly output", "first_output_rule": "Publish a current benchmark immediately; call it an index only after 12 monthly snapshots", "planned_external_source": "Sprinkle listings plus a daily FX reference", "planned_source_url": null }, { "idea_number": 3, "slug": "most-traded-airplane", "idea": "Most Traded Airplane", "worker_url": "https://sprinkle-pr-data-seeds.alexdunsdonagent.workers.dev/jobs/3", "seed_status": "collector live — monthly history", "generated_on": "2026-07-31", "current_record_summary": "1 of 24 monthly snapshots; 308,578 current collector rows; 0 later change events; history building", "current_metrics": { "registration_history": { "rows": 399135, "aircraft": 399133, "latest_valid_from": "2026-05-01T13:28:54.397007+00:00", "extra_history_rows": 2, "earliest_valid_from": "2026-05-01T08:09:06.587513+00:00" }, "faa": { "total_rows": 314707, "valid_rows": 308578, "valid_with_year": 242965, "valid_with_owner": 305189, "valid_state_codes": 58, "valid_with_county": 304424, "valid_owner_mentions_trust": 13137 }, "history_collector_maturity": { "data_generated_on": "2026-07-31", "data_checked_at": "2026-07-31T19:18:42Z", "idea_number": "3", "idea": "Most Traded Airplane", "source_collector": "Monthly FAA registration history", "cadence": "Monthly · first day at 05:30 UTC", "earliest_snapshot": "2026-07-01", "latest_snapshot": "2026-07-01", "distinct_snapshots": "1", "observed_days": "1", "observed_months": "1", "current_rows": "308578", "baseline_events": "308578", "change_events": "0", "current_sold_status_rows": "", "event_detail": "0 owner, state, model or register-exit changes", "source_tables": "Cloudflare registration_tracker_runs; Sprinkle _gdb_registration_history; stg_faa_v2_master", "required_gate": "24 comparable monthly snapshots before any model trade ranking", "gate_progress": "1 of 24 monthly snapshots", "earliest_plausible_eligibility": "2028-06-01", "eligibility_state": "history_building", "exact_blocker": "Only the July 2026 baseline exists. A first baseline cannot reveal an owner transfer, and no later owner-change event has yet been observed." } }, "source_tables": [ "_gdb_registration_history", "stg_faa_v2_master" ], "requested_fields": "N-number; serial number; registered owner; registration state; snapshot date", "still_missing": "One monthly FAA baseline exists from July 2026, with zero later change events. The model trade ranking requires 24 comparable snapshots and cannot reach its time gate before June 2028.", "collection_plan": "Download the complete FAA release; match aircraft by serial number; save owner changes only when the normalized owner differs", "frequency": "Monthly", "first_output_rule": "Wait for at least 24 monthly snapshots before ranking", "planned_external_source": "FAA Releasable Aircraft Database archived into Sprinkle", "planned_source_url": "https://registry.faa.gov/database/" }, { "idea_number": 4, "slug": "anonymity-index", "idea": "Anonymity Index", "worker_url": "https://sprinkle-pr-data-seeds.alexdunsdonagent.workers.dev/jobs/4", "seed_status": "ownership-structure review live — anonymity score withheld", "generated_on": "2026-07-31", "current_record_summary": "58 state and territory rows; 98,023 registrations with explicit structure indicators; 0 rules approved for an anonymity score", "current_metrics": { "faa": { "total_rows": 314707, "valid_rows": 308578, "valid_with_year": 242965, "valid_with_owner": 305189, "valid_state_codes": 58, "valid_with_county": 304424, "valid_owner_mentions_trust": 13137 }, "registration_history": { "rows": 399135, "aircraft": 399133, "latest_valid_from": "2026-05-01T13:28:54.397007+00:00", "extra_history_rows": 2, "earliest_valid_from": "2026-05-01T08:09:06.587513+00:00" }, "job_4_output": { "generated_on": "2026-07-31", "state_and_territory_rows": 58, "valid_registrations": 304526, "explicit_structure_indicator_registrations": 98023, "owner_name_mentions_trustee": 12406, "owner_name_mentions_trust": 1457, "owner_name_mentions_llc": 86071, "rules_approved_for_anonymity_score": 0, "methodology": "Current valid FAA registrations aggregated by state using official registrant-type codes and literal whole-word TRUSTEE, TRUST and LLC owner-name indicators.", "caveat": "These fields describe legal or textual structure. They do not establish beneficial-owner secrecy and are not an anonymity score." } }, "source_tables": [ "stg_faa_v2_master", "_gdb_registration_history" ], "requested_fields": "Owner name; registrant type; address; trustee/shell classification; snapshot date", "still_missing": "A transparent ownership-structure review is live. All proposed rules remain unapproved for an anonymity score, and beneficial ownership still requires case-by-case research.", "collection_plan": "Refresh the registry; publish transparent registrant-type and literal structure indicators; apply an anonymity score only after rules are approved", "frequency": "Monthly; annual trend", "first_output_rule": "Publish the transparent review baseline now; call it an index only after the classification rules are manually approved", "planned_external_source": "FAA registry plus a reviewed Sprinkle classification list", "planned_source_url": "https://registry.faa.gov/database/" }, { "idea_number": 5, "slug": "no-carfax-at-5-000-feet", "idea": "No Carfax at 5,000 Feet", "worker_url": "https://sprinkle-pr-data-seeds.alexdunsdonagent.workers.dev/jobs/5", "seed_status": "full-archive exact-match output live — monthly batch", "generated_on": "2026-07-31", "current_record_summary": "55 active listings with exact registration-and-serial matches across 56 NTSB events; 6,529 listings checked", "current_metrics": { "faa": { "total_rows": 314707, "valid_rows": 308578, "valid_with_year": 242965, "valid_with_owner": 305189, "valid_state_codes": 58, "valid_with_county": 304424, "valid_owner_mentions_trust": 13137 }, "dealer_listings": { "total_rows": 13904, "active_rows": 6801, "active_priced_rows": 2033, "latest_active_posted_at": "2026-06-01T15:46:08.701+00:00", "active_priced_currencies": 5, "earliest_active_posted_at": "2025-10-10T15:02:52.208+00:00" }, "portal_listings": { "sold_rows": 6, "total_rows": 51, "active_rows": 35, "active_priced_rows": 23 }, "job_5_output": { "generated_on": "2026-07-31", "ntsb_dataset_start": "1962-01-01", "active_listings_checked": 6529, "exact_listing_event_matches": 56, "unique_listings": 55, "substantial_or_destroyed": 52, "matching_rule": "The active listing and NTSB aircraft record must have the same normalized US registration and serial number.", "coverage": "NTSB downloadable aviation archives from 1962 onward.", "limitation": "Exact identifier matching can miss records with absent or mistyped registrations or serial numbers; every result still requires report, seller and maintenance-record verification.", "source_urls": [ "https://data.ntsb.gov/avdata/FileDirectory/DownloadFile?fileID=C%3A%5Cavdata%5Cavall.zip", "https://data.ntsb.gov/avdata/FileDirectory/DownloadFile?fileID=C%3A%5Cavdata%5CPre2008.zip", "https://data.ntsb.gov/avdata/FileDirectory/DownloadFile?fileID=C%3A%5Cavdata%5CPRE1982.zip" ] } }, "source_tables": [ "stg_faa_v2_master", "_gdb_dealer_listing", "_gdb_model", "_gdb_family", "_gdb_category", "_gdb_manufacturer", "_gdb_mkt_aircraft_listing" ], "requested_fields": "Active listing URL; NTSB event ID and number; event date; US registration; serial number; make/model; damage; injury level; report status", "still_missing": "The full downloadable NTSB archive has been matched from 1962 onward. Seller, repair, maintenance-record and current-condition verification remain editorial checks.", "collection_plan": "Run as a monthly batch because the archives expand above 1.6 GB; combine 1962–1981, 1982–2007 and current records; publish only registration-and-serial matches", "frequency": "Monthly batch", "first_output_rule": "Publish exact registration-and-serial matches only; require NTSB report, seller, repair and maintenance-record verification", "planned_external_source": "All three NTSB downloadable aviation archives and Sprinkle active listings", "planned_source_url": "https://www.ntsb.gov/safety/data/pages/Data_Stats.aspx" }, { "idea_number": 6, "slug": "aircraft-market-heat-index", "idea": "Aircraft Market Heat Index", "worker_url": "https://sprinkle-pr-data-seeds.alexdunsdonagent.workers.dev/jobs/6", "seed_status": "title-screened listing tracker live — daily collector; demand withheld", "generated_on": "2026-07-31", "current_record_summary": "4,823 active-status rows reviewed; 2,246 title-consistent rows across 584 model groups; 2,577 taxonomy-review rows; 0 demand-eligible models", "current_metrics": { "demand": { "wanted_rows": 14, "saved_search_rows": 3, "active_wanted_rows": 8 }, "dealer_listings": { "total_rows": 13904, "active_rows": 6801, "active_priced_rows": 2033, "latest_active_posted_at": "2026-06-01T15:46:08.701+00:00", "active_priced_currencies": 5, "earliest_active_posted_at": "2025-10-10T15:02:52.208+00:00" }, "portal_listings": { "sold_rows": 6, "total_rows": 51, "active_rows": 35, "active_priced_rows": 23 }, "job_6_output": { "generated_on": "2026-07-31", "output_type": "Title-screened observed listing tracker and taxonomy-review queue; not a demand ranking or price index.", "model_rows": 584, "collector_active_status_listing_rows": 4823, "title_consistent_listing_rows": 2246, "taxonomy_review_required_rows": 2577, "title_consistent_rows_without_sold_flag": 2141, "title_consistent_sold_flag_conflict_rows": 105, "title_consistent_priced_rows": 765, "title_consistent_source_link_rows": 2238, "rows_without_sold_flag": 4612, "sold_flag_conflict_rows": 211, "duplicate_flag_rows": 0, "priced_rows": 1468, "source_link_rows": 4815, "buyer_signal_window_days": 90, "raw_buyer_signal_events": 44, "mapped_buyer_signal_events": 28, "minimum_unique_buyers_per_published_model": 3, "minimum_active_listings_per_published_model": 3, "collector_demand_eligible_models": 0, "title_screened_demand_eligible_models": 0, "model_level_demand_published": false, "cadence": "Supply and aggregate demand are collected daily at 04:45 UTC; the journalist-facing output is reviewed weekly.", "source_tables": [ "_gdb_dealer_listing", "_gdb_mkt_aircraft_listing", "_gdb_model", "_gdb_manufacturer", "_gdb_mkt_listing_inquiry", "_gdb_mkt_aircraft_wanted", "_gdb_mkt_saved_search" ], "privacy_rule": "Model-level buyer counts are withheld unless a model has at least three unique buyers and three active-status listing rows.", "taxonomy_gate": "The public aggregate includes a row only when the listing title independently contains both a conservative manufacturer/brand token and the linked model designation. All other collector links remain in the complete CSV as taxonomy review required.", "limitations": [ "The supply figures are an observed Sprinkle listing-feed snapshot, not a census of the whole aircraft market.", "Active-status rows can conflict with a separate sold flag; those rows remain in the collector total but are labelled for editorial filtering.", "Listings can be duplicated, stale, incomplete or removed after the snapshot date.", "Asking prices are not completed-sale prices, and no price movement is calculated from this single snapshot.", "Buyer signals are product events, not completed purchases or a representative market survey." ] } }, "source_tables": [ "_gdb_mkt_listing_inquiry", "_gdb_mkt_aircraft_wanted", "_gdb_mkt_saved_search", "_gdb_dealer_listing", "_gdb_model", "_gdb_family", "_gdb_category", "_gdb_manufacturer", "_gdb_mkt_aircraft_listing" ], "requested_fields": "Listing source and URL; linked manufacturer/model; advert title; active/sold flags; taxonomy check; aggregate buyer-signal gate", "still_missing": "A title-screened listing and taxonomy-review output is live. No model yet meets the fixed minimum of 3 unique buyers and 3 title-consistent active listings, so model-level demand remains withheld.", "collection_plan": "Snapshot active-status rows; require the advert title to confirm both manufacturer/brand and model for the public aggregate; retain failed links as a labelled review queue; suppress sub-threshold demand", "frequency": "Daily collection; weekly output", "first_output_rule": "Publish the title-screened supply and taxonomy-review files now; publish no model demand until at least 3 unique buyers and 3 title-consistent active listings", "planned_external_source": "Sprinkle listings and consented buyer-intent events", "planned_source_url": null }, { "idea_number": 7, "slug": "tail-number-time-machine", "idea": "Tail Number Time Machine", "worker_url": "https://sprinkle-pr-data-seeds.alexdunsdonagent.workers.dev/jobs/7", "seed_status": "collector live — monthly history", "generated_on": "2026-07-31", "current_record_summary": "1 of 12 monthly snapshots; 308,578 current collector rows; 0 later change events; history building", "current_metrics": { "registration_history": { "rows": 399135, "aircraft": 399133, "latest_valid_from": "2026-05-01T13:28:54.397007+00:00", "extra_history_rows": 2, "earliest_valid_from": "2026-05-01T08:09:06.587513+00:00" }, "faa": { "total_rows": 314707, "valid_rows": 308578, "valid_with_year": 242965, "valid_with_owner": 305189, "valid_state_codes": 58, "valid_with_county": 304424, "valid_owner_mentions_trust": 13137 }, "history_collector_maturity": { "data_generated_on": "2026-07-31", "data_checked_at": "2026-07-31T19:18:42Z", "idea_number": "7", "idea": "Tail Number Time Machine", "source_collector": "Monthly FAA registration history", "cadence": "Monthly · first day at 05:30 UTC", "earliest_snapshot": "2026-07-01", "latest_snapshot": "2026-07-01", "distinct_snapshots": "1", "observed_days": "1", "observed_months": "1", "current_rows": "308578", "baseline_events": "308578", "change_events": "0", "current_sold_status_rows": "", "event_detail": "0 owner, state, model or register-exit changes", "source_tables": "Cloudflare registration_tracker_runs; Sprinkle _gdb_registration_history; stg_faa_v2_master", "required_gate": "12 comparable monthly snapshots; earlier timelines must be labelled incomplete", "gate_progress": "1 of 12 monthly snapshots", "earliest_plausible_eligibility": "2027-06-01", "eligibility_state": "history_building", "exact_blocker": "Only one monthly baseline exists, so the collector has no later owner, state, model or register-exit change to place on a timeline." } }, "source_tables": [ "_gdb_registration_history", "stg_faa_v2_master" ], "requested_fields": "Serial number; N-number; owner; location; status; action date; snapshot date", "still_missing": "One monthly FAA baseline exists from July 2026, with zero later change events. An incomplete tail-number timeline needs 12 comparable snapshots and cannot reach its time gate before June 2027.", "collection_plan": "Download each release; match by serial number; append owner, N-number, state and status changes to a timeline", "frequency": "Monthly", "first_output_rule": "Launch lookup after at least 12 snapshots; label earlier history incomplete", "planned_external_source": "FAA Releasable Aircraft Database archived into Sprinkle", "planned_source_url": "https://registry.faa.gov/database/" }, { "idea_number": 9, "slug": "verified-dealer-awards", "idea": "Verified Dealer Awards", "worker_url": "https://sprinkle-pr-data-seeds.alexdunsdonagent.workers.dev/jobs/9", "seed_status": "claimed-profile readiness directory live — daily source check; awards withheld", "generated_on": "2026-07-31", "current_record_summary": "11 claimed, non-hidden dealer profiles; 3 valid public business websites; 0 approved awards", "current_metrics": { "dealers": { "claimed_rows": 17, "profile_rows": 4484 }, "job_9_output": { "generated_on": "2026-07-31", "source_dealer_profiles": 4484, "source_claimed_profiles": 17, "source_claimed_non_hidden_profiles": 11, "published_readiness_rows": 11, "source_rows_with_business_website": 11, "rows_with_public_business_website": 3, "suppressed_placeholder_or_invalid_websites": 8, "rows_with_public_categories": 11, "rows_with_profile_city": 3, "suppressed_location_conflicts": 1, "editorially_approved_rows": 0, "approved_awards": 0, "refresh_cadence": "On each data-room publish; recommended daily while claims are changing", "source": "Sprinkle v2 _gdb_dealer_profile joined to _gdb_organization", "methodology": "Publish only claimed, non-hidden dealer profiles linked to an unmerged DEALER organisation. Export public business identity and safe profile fields; omit personal contacts and street addresses, suppress placeholder or invalid websites, and suppress profile locations that conflict with the organisation headquarters country.", "caveat": "Claim status confirms only the profile-account signal stored by Sprinkle. It does not establish service quality, customer satisfaction, verification beyond the account claim, award eligibility or an award winner." } }, "source_tables": [ "_gdb_dealer_profile", "_gdb_organization" ], "requested_fields": "Dealer profile ID; public business identity; claim and visibility flags; public categories; review and approval fields", "still_missing": "A safe claimed-profile readiness directory is live. Award criteria, service evidence, editorial approvals and a sufficient reviewed sample are still required before any award or verification claim.", "collection_plan": "Refresh claimed, non-hidden dealer profiles; suppress personal contacts, placeholder links and conflicting locations; export a dated editorial queue", "frequency": "Daily source check; annual awards only after approval", "first_output_rule": "Publish the claimed-profile readiness directory now; do not call a business verified, shortlisted or a winner without approved criteria and evidence", "planned_external_source": "Sprinkle dealer and organisation records", "planned_source_url": null }, { "idea_number": 10, "slug": "100-hamburger-index", "idea": "$100 Hamburger Index", "worker_url": "https://sprinkle-pr-data-seeds.alexdunsdonagent.workers.dev/jobs/10", "seed_status": "first FAA Part 91 flight-cost benchmark live — annual", "generated_on": "2026-07-31", "current_record_summary": "14 FAA categories; 33,245 Sprinkle variants mapped; small-piston two-hour variable benchmark $522–$544; meal and route fees excluded", "current_metrics": { "performance": { "rows": 65563, "with_cruise_speed": 47943, "with_fuel_capacity": 45655, "with_landing_distance": 40396, "with_takeoff_distance": 41196 }, "airports": { "runway_rows": 25589, "open_runways": 24945, "aerodrome_rows": 71957, "operational_aerodromes": 71957 }, "job_10_output": { "generated_on": "2026-07-31", "source_edition": "Economic Values for FAA Investment and Regulatory Decisions: 2024 Update", "source_published": "2024-11", "faa_source_url": "https://www.faa.gov/regulations_policies/policy_guidance/benefit_cost/econ-value-section-4-op-costs.pdf", "faa_guide_url": "https://www.faa.gov/regulations_policies/policy_guidance/benefit_cost", "faa_table": "Table 4-12", "benchmark_flight_hours": 2, "sprinkle_variants_evaluated": 54656, "sprinkle_variants_mapped": 33245, "faa_categories_with_sprinkle_matches": 14, "piston_1_3_variable_benchmark_usd": 522, "piston_1_3_total_benchmark_usd": 1202, "piston_4_9_single_variable_benchmark_usd": 544, "piston_4_9_single_total_benchmark_usd": 1306, "faa_fuel_assumption": "Table 4-11 uses $6.53 per gallon for piston fuel and $6.28 per gallon for turbine fuel; Table 4-12 rolls fuel, oil, maintenance and crew into the Part 91 variable cost.", "methodology": "Map one preferred Sprinkle performance record per variant to the FAA's aircraft categories using propulsion, engine count, seats, rotorcraft taxonomy and MTOW, then multiply the FAA Part 91 hourly benchmark by a fixed two flight hours.", "excluded": [ "meal price", "route-specific landing or parking fees", "taxi time", "weather or diversion costs", "aircraft-specific utilization and financing" ], "caveat": "This is an FAA category-level economic benchmark, not a quote, flight plan, reimbursement rate or claim about a specific aircraft's actual cost.", "refresh": "Annual, or when the FAA replaces the source guide" } }, "source_tables": [ "_gdb_variant_performance", "_gdb_aerodrome", "_gdb_runway" ], "requested_fields": "FAA Part 91 variable and total hourly cost; FAA aircraft category; Sprinkle variant taxonomy; seats; engine count; MTOW; fixed flight hours", "still_missing": "A fixed two-flight-hour FAA Part 91 cost benchmark is live. Meal prices, live fuel prices and route-specific landing or parking fees remain excluded until approved sources exist.", "collection_plan": "Refresh the official FAA guide; map Sprinkle variants to FAA categories; multiply the category hourly benchmark by a fixed two flight hours; exclude meal and route-specific fees", "frequency": "Annual, or when the FAA guide changes", "first_output_rule": "Publish the fixed flight-cost benchmark now; do not present it as an actual trip quote, live fuel price or complete meal-and-fees index", "planned_external_source": "FAA Economic Values operating-cost guide plus Sprinkle performance and aircraft taxonomy", "planned_source_url": "https://www.faa.gov/regulations_policies/policy_guidance/benefit_cost/econ-value-section-4-op-costs.pdf" }, { "idea_number": 11, "slug": "december-effect", "idea": "December Effect", "worker_url": "https://sprinkle-pr-data-seeds.alexdunsdonagent.workers.dev/jobs/11", "seed_status": "collector live — monthly history", "generated_on": "2026-07-31", "current_record_summary": "0 of 3 complete calendar years; 308,578 current collector rows; 0 later change events; history building", "current_metrics": { "registration_history": { "rows": 399135, "aircraft": 399133, "latest_valid_from": "2026-05-01T13:28:54.397007+00:00", "extra_history_rows": 2, "earliest_valid_from": "2026-05-01T08:09:06.587513+00:00" }, "history_collector_maturity": { "data_generated_on": "2026-07-31", "data_checked_at": "2026-07-31T19:18:42Z", "idea_number": "11", "idea": "December Effect", "source_collector": "Monthly FAA registration history", "cadence": "Monthly · first day at 05:30 UTC", "earliest_snapshot": "2026-07-01", "latest_snapshot": "2026-07-01", "distinct_snapshots": "1", "observed_days": "1", "observed_months": "1", "current_rows": "308578", "baseline_events": "308578", "change_events": "0", "current_sold_status_rows": "", "event_detail": "0 owner, state, model or register-exit changes", "source_tables": "Cloudflare registration_tracker_runs; Sprinkle _gdb_registration_history", "required_gate": "Three complete calendar years before comparing December with other months", "gate_progress": "0 of 3 complete calendar years", "earliest_plausible_eligibility": "2030-01-01", "eligibility_state": "history_building", "exact_blocker": "Collection began in July 2026. No complete calendar year—and no observed December owner-change period—exists yet." } }, "source_tables": [ "_gdb_registration_history" ], "requested_fields": "Serial number; old owner; new owner; effective month; registry snapshot date", "still_missing": "Collection began in July 2026, so zero complete calendar years exist. The seasonal comparison requires three complete years and cannot reach its time gate before January 2030.", "collection_plan": "Download every release; detect normalized owner changes; compare December changes with other months", "frequency": "Monthly; annual output", "first_output_rule": "Wait for at least three complete calendar years", "planned_external_source": "FAA Releasable Aircraft Database archived into Sprinkle", "planned_source_url": "https://registry.faa.gov/database/" }, { "idea_number": 12, "slug": "great-hangar-handover", "idea": "Great Hangar Handover", "worker_url": "https://sprinkle-pr-data-seeds.alexdunsdonagent.workers.dev/jobs/12", "seed_status": "aircraft ownership base", "generated_on": "2026-07-31", "current_record_summary": "1 of 24 snapshots; proxy not approved; 308,578 current collector rows; 0 later change events; history and method gate", "current_metrics": { "registration_history": { "rows": 399135, "aircraft": 399133, "latest_valid_from": "2026-05-01T13:28:54.397007+00:00", "extra_history_rows": 2, "earliest_valid_from": "2026-05-01T08:09:06.587513+00:00" }, "airframes": { "rows": 695125, "with_year": 424142, "with_model": 628418, "active_rows": 436176, "with_country": 456484 }, "history_collector_maturity": { "data_generated_on": "2026-07-31", "data_checked_at": "2026-07-31T19:18:42Z", "idea_number": "12", "idea": "Great Hangar Handover", "source_collector": "Monthly FAA registration history", "cadence": "Monthly · first day at 05:30 UTC", "earliest_snapshot": "2026-07-01", "latest_snapshot": "2026-07-01", "distinct_snapshots": "1", "observed_days": "1", "observed_months": "1", "current_rows": "308578", "baseline_events": "308578", "change_events": "0", "current_sold_status_rows": "", "event_detail": "0 owner, state, model or register-exit changes", "source_tables": "Cloudflare registration_tracker_runs; Sprinkle _gdb_registration_history; _gdb_airframe (695,125 supporting rows)", "required_gate": "24 monthly snapshots, reliable aircraft identity matches and an approved handover proxy", "gate_progress": "1 of 24 snapshots; proxy not approved", "earliest_plausible_eligibility": "2028-06-01 (history gate only)", "eligibility_state": "history_and_method_gate", "exact_blocker": "Owner age and inheritance are not present. Even after 24 snapshots, the feature cannot publish until editors approve a defensible handover proxy and uncertain matches are excluded." } }, "source_tables": [ "_gdb_registration_history", "_gdb_airframe" ], "requested_fields": "Serial number; owner; ownership start; ownership end; manufacture year; aircraft type", "still_missing": "One of 24 monthly snapshots exists. Owner age and inheritance are not available, so publication also requires an approved handover proxy and reliable identity matching.", "collection_plan": "Build ownership periods from consecutive monthly snapshots; calculate tenure by aircraft age and type", "frequency": "Monthly; annual output", "first_output_rule": "Wait for at least 24 snapshots and exclude uncertain identity matches", "planned_external_source": "FAA registry snapshots plus Sprinkle aircraft reference data", "planned_source_url": "https://registry.faa.gov/database/" }, { "idea_number": 13, "slug": "county-s-air-force", "idea": "County’s Air Force", "worker_url": "https://sprinkle-pr-data-seeds.alexdunsdonagent.workers.dev/jobs/13", "seed_status": "first county ranking live — annual", "generated_on": "2026-07-31", "current_record_summary": "3,144 counties and county equivalents; 300,262 FAA registrations matched", "current_metrics": { "faa": { "total_rows": 314707, "valid_rows": 308578, "valid_with_year": 242965, "valid_with_owner": 305189, "valid_state_codes": 58, "valid_with_county": 304424, "valid_owner_mentions_trust": 13137 }, "job_13_output": { "generated_on": "2026-07-30", "population_year": 2025, "county_count": 3144, "matched_aircraft": 300262, "unmatched_faa_counties": 50, "census_source_url": "https://www2.census.gov/programs-surveys/popest/datasets/2020-2025/counties/totals/co-est2025-alldata.csv", "top_county": "Bristol Bay Borough", "top_state": "Alaska", "top_aircraft_per_100k": 12987.01, "methodology": "Valid FAA registrations grouped by FAA county code, joined to the latest available Census county population estimate and ranked by aircraft per 100,000 residents.", "caveat": "Registration location is the registered owner address and is not necessarily the aircraft operating base." } }, "source_tables": [ "stg_faa_v2_master" ], "requested_fields": "County FIPS; county population; valid aircraft count; aircraft type and age", "still_missing": "The live per-capita county ranking is complete; military-style comparisons remain optional editorial framing.", "collection_plan": "Download the latest county population/geography files; join FAA county codes; calculate aircraft per person", "frequency": "Annual", "first_output_rule": "Publish once the county-code crosswalk and missing-record rules are checked", "planned_external_source": "US Census ACS population and TIGER county geography plus FAA data", "planned_source_url": "https://www.census.gov/programs-surveys/geography/guidance/tiger-data-products-guide.html" }, { "idea_number": 14, "slug": "jet-set-barometer", "idea": "Jet Set Barometer", "worker_url": "https://sprinkle-pr-data-seeds.alexdunsdonagent.workers.dev/jobs/14", "seed_status": "title-screened jet supply tracker live — daily collector; demand withheld", "generated_on": "2026-07-31", "current_record_summary": "1,433 active business-jet rows reviewed; 648 title-screened rows across 50 families; 785 review/exclusion rows; 0 demand-eligible families", "current_metrics": { "demand": { "wanted_rows": 14, "saved_search_rows": 3, "active_wanted_rows": 8 }, "dealer_listings": { "total_rows": 13904, "active_rows": 6801, "active_priced_rows": 2033, "latest_active_posted_at": "2026-06-01T15:46:08.701+00:00", "active_priced_currencies": 5, "earliest_active_posted_at": "2025-10-10T15:02:52.208+00:00" }, "portal_listings": { "sold_rows": 6, "total_rows": 51, "active_rows": 35, "active_priced_rows": 23 }, "job_14_output": { "generated_on": "2026-07-31", "aggregate_queried_at": "2026-07-31T19:12:47.495332+00:00", "output_type": "Title-screened observed business-jet supply tracker; no demand ranking.", "collector_active_business_jet_listing_rows": 1433, "collector_mapped_family_or_model_groups": 91, "collector_mapped_buyer_signal_events": 11, "demand_eligible_families": 0, "public_family_rows": 50, "public_title_screened_supply_rows": 648, "direct_family_title_match_rows": 342, "via_linked_model_title_match_rows": 306, "taxonomy_review_or_exclusion_rows": 785, "rows_without_normalized_family": 67, "manufacturer_title_mismatch_rows": 342, "family_and_model_title_mismatch_rows": 351, "family_model_relationship_conflict_rows": 288, "brand_manufacturer_conflict_rows": 149, "non_business_jet_category_warning_rows": 5, "sold_flag_conflict_rows": 61, "duplicate_flag_rows": 0, "buyer_signal_window_days": 90, "minimum_unique_buyers_per_published_family": 3, "minimum_active_listings_per_published_family": 3, "demand_published": false, "cadence": "Supply and aggregate demand are collected daily at 04:45 UTC; the journalist-facing title screen is reviewed weekly.", "source_tables": [ "_gdb_dealer_listing", "_gdb_mkt_aircraft_listing", "_gdb_model", "_gdb_family", "_gdb_category", "_gdb_manufacturer", "_gdb_mkt_listing_inquiry", "_gdb_mkt_aircraft_wanted", "_gdb_mkt_saved_search" ], "privacy_rule": "Family-level demand is published only after the family has at least three unique buyers and three active listings. No family passed, so all family names and counts tied to sub-threshold demand are withheld.", "taxonomy_gate": "A supply row is counted only when it has a normalized family, the advert title confirms the linked manufacturer or a recognized brand, the title confirms either that family or its linked model, and the linked family and model names agree. Recognized brand/manufacturer conflicts, non-business-jet category warnings, sold-flag conflicts and duplicate-marked rows are excluded.", "limitations": [ "The supply figures cover observed Sprinkle feeds, not the whole business-jet market.", "Title screening is conservative: it can exclude valid abbreviations, historical brands and variant names, and it is not a substitute for checking the source advert.", "A title-confirmed model inherits its normalized family relationship from Sprinkle; that database relationship can still require editorial correction.", "Active listings can become stale or be removed after the observation date.", "This edition publishes no buyer counts, demand scores, popularity ranking, price trend or completed-sale measure." ] } }, "source_tables": [ "_gdb_mkt_listing_inquiry", "_gdb_mkt_aircraft_wanted", "_gdb_mkt_saved_search", "_gdb_dealer_listing", "_gdb_model", "_gdb_family", "_gdb_category", "_gdb_manufacturer", "_gdb_mkt_aircraft_listing" ], "requested_fields": "Business-jet listing title and URL; linked manufacturer/model/family/category; active/sold/duplicate flags; taxonomy checks; aggregate buyer-signal gate", "still_missing": "A title-screened business-jet supply and taxonomy-review output is live. No family meets the fixed 3-buyer, 3-listing publication gate, so family demand, scoring and ranking remain withheld.", "collection_plan": "Keep normalized BUSINESS_JET rows; require the title to confirm manufacturer/brand and family or linked model; exclude family/model conflicts, sold conflicts and duplicates; suppress sub-threshold demand", "frequency": "Daily collection; weekly output", "first_output_rule": "Publish title-screened family supply and the labelled review file now; publish no demand score or ranking until a family has at least 3 unique buyers and 3 active listings", "planned_external_source": "Sprinkle jet listings and consented buyer-intent events", "planned_source_url": null }, { "idea_number": 15, "slug": "aircraft-liquidity-index", "idea": "Aircraft Liquidity Index", "worker_url": "https://sprinkle-pr-data-seeds.alexdunsdonagent.workers.dev/jobs/15", "seed_status": "collector live — daily history", "generated_on": "2026-07-31", "current_record_summary": "2 of 90 observed days; outcome threshold not yet met; 13,955 current collector rows; 0 later change events; history building", "current_metrics": { "dealer_listings": { "total_rows": 13904, "active_rows": 6801, "active_priced_rows": 2033, "latest_active_posted_at": "2026-06-01T15:46:08.701+00:00", "active_priced_currencies": 5, "earliest_active_posted_at": "2025-10-10T15:02:52.208+00:00" }, "portal_listings": { "sold_rows": 6, "total_rows": 51, "active_rows": 35, "active_priced_rows": 23 }, "listing_metrics": { "snapshot_rows": 19, "latest_snapshot_date": "2026-07-31", "earliest_snapshot_date": "2026-07-03" }, "history_collector_maturity": { "data_generated_on": "2026-07-31", "data_checked_at": "2026-07-31T19:18:42Z", "idea_number": "15", "idea": "Aircraft Liquidity Index", "source_collector": "Daily listing-state history", "cadence": "Daily · 05:15 UTC; monthly registry validation", "earliest_snapshot": "2026-07-30", "latest_snapshot": "2026-07-31", "distinct_snapshots": "2", "observed_days": "2", "observed_months": "1", "current_rows": "13955", "baseline_events": "13955", "change_events": "0", "current_sold_status_rows": "393", "event_detail": "13,955 first-observed events; 0 later change events", "source_tables": "Cloudflare listing_tracker_runs/current/events; Sprinkle dealer and marketplace listings", "required_gate": "At least 90 observed days plus enough confirmed outcomes in each published segment", "gate_progress": "2 of 90 observed days; outcome threshold not yet met", "earliest_plausible_eligibility": "2026-10-28 (conditional)", "eligibility_state": "history_building", "exact_blocker": "The two snapshots contain no later status or price change event. Existing sold-status rows predate the collector and do not establish an observed time-to-sale outcome." } }, "source_tables": [ "_gdb_dealer_listing", "_gdb_model", "_gdb_family", "_gdb_category", "_gdb_manufacturer", "_gdb_mkt_aircraft_listing", "_gdb_mkt_listing_metrics_daily" ], "requested_fields": "Listing ID; serial number; first seen; last seen; sold/withdrawn/relisted status; price", "still_missing": "Two of 90 required observed days exist, with zero later listing-state changes. The conditional time gate is 28 October 2026 and segment outcome thresholds must still pass.", "collection_plan": "Save every listing state; identify disappearance and relisting; confirm sales where later registry evidence exists", "frequency": "Daily listings; monthly validation", "first_output_rule": "Publish only segments with enough confirmed outcomes", "planned_external_source": "Sprinkle listing snapshots with later FAA registry checks", "planned_source_url": null }, { "idea_number": 16, "slug": "ownership-churn-index", "idea": "Ownership Churn Index", "worker_url": "https://sprinkle-pr-data-seeds.alexdunsdonagent.workers.dev/jobs/16", "seed_status": "collector live — monthly history", "generated_on": "2026-07-31", "current_record_summary": "1 of 36 monthly snapshots; model samples not testable yet; 308,578 current collector rows; 0 later change events; history building", "current_metrics": { "registration_history": { "rows": 399135, "aircraft": 399133, "latest_valid_from": "2026-05-01T13:28:54.397007+00:00", "extra_history_rows": 2, "earliest_valid_from": "2026-05-01T08:09:06.587513+00:00" }, "airframes": { "rows": 695125, "with_year": 424142, "with_model": 628418, "active_rows": 436176, "with_country": 456484 }, "history_collector_maturity": { "data_generated_on": "2026-07-31", "data_checked_at": "2026-07-31T19:18:42Z", "idea_number": "16", "idea": "Ownership Churn Index", "source_collector": "Monthly FAA registration history", "cadence": "Monthly · first day at 05:30 UTC", "earliest_snapshot": "2026-07-01", "latest_snapshot": "2026-07-01", "distinct_snapshots": "1", "observed_days": "1", "observed_months": "1", "current_rows": "308578", "baseline_events": "308578", "change_events": "0", "current_sold_status_rows": "", "event_detail": "0 owner, state, model or register-exit changes", "source_tables": "Cloudflare registration_tracker_runs; Sprinkle _gdb_registration_history; _gdb_airframe (695,125 supporting rows)", "required_gate": "At least three observed years and a sufficient aircraft sample for each model", "gate_progress": "1 of 36 monthly snapshots; model samples not testable yet", "earliest_plausible_eligibility": "2029-07-01 (conditional)", "eligibility_state": "history_building", "exact_blocker": "Only the first monthly baseline exists. There are no observed owner-change events from which to calculate transfers per observed year." } }, "source_tables": [ "_gdb_registration_history", "_gdb_airframe" ], "requested_fields": "Serial number; model; owner-change dates; number of owners; observed history length", "still_missing": "One of 36 monthly snapshots exists, with zero later owner changes. The conditional three-year time gate is July 2029 and model sample thresholds must still pass.", "collection_plan": "Append normalized owner changes; calculate transfers per observed year by model", "frequency": "Monthly; annual output", "first_output_rule": "Wait for at least three years and a minimum aircraft sample per model", "planned_external_source": "FAA Releasable Aircraft Database archived into Sprinkle", "planned_source_url": "https://registry.faa.gov/database/" }, { "idea_number": 17, "slug": "offshore-jet-registry-league", "idea": "Offshore Jet Registry League", "worker_url": "https://sprinkle-pr-data-seeds.alexdunsdonagent.workers.dev/jobs/17", "seed_status": "official FAA/CAA recent-changes baseline live — fortnightly/daily; league withheld", "generated_on": "2026-07-31", "current_record_summary": "11 recent CAA jet registrations; 5 outward jet transfer notices; 0 jet FAA historical overlaps; league and migration claims withheld", "current_metrics": { "registration_history": { "rows": 399135, "aircraft": 399133, "latest_valid_from": "2026-05-01T13:28:54.397007+00:00", "extra_history_rows": 2, "earliest_valid_from": "2026-05-01T08:09:06.587513+00:00" }, "airframes": { "rows": 695125, "with_year": 424142, "with_model": 628418, "active_rows": 436176, "with_country": 456484 }, "job_17_output": { "generated_on": "2026-07-31", "caa_source_as_at": "2026-07-20", "caa_recent_window_start": "2026-05-25", "caa_recent_window_end": "2026-07-19", "caa_recent_registrations_reviewed": 73, "caa_recent_deregistrations_reviewed": 74, "caa_recent_jet_registrations": 11, "caa_recent_jet_outward_transfer_notices": 5, "business_jet_actions": 4, "airline_jet_actions": 12, "faa_source_date": "2026-07-30", "faa_aircraft_reference_rows": 93934, "faa_master_rows": 315163, "faa_valid_current_rows": 308988, "faa_deregistered_rows": 382958, "caa_registrations_with_compatible_current_faa_record": 0, "caa_registrations_with_historical_faa_serial_model_overlap": 12, "caa_jet_registrations_with_historical_faa_serial_model_overlap": 0, "caa_historical_overlaps_with_faa_uk_destination": 5, "method": "Review all aircraft registered in the four public CAA recent-registration windows. Match only exact cleaned serial numbers, then require a compatible manufacturer family and model string in the FAA reference file. Search both current FAA master and historical FAA deregistered records. Publish no owner names.", "publication_scope": "A narrow recent UK jet-actions baseline and a technical UK-US serial/model overlap review. It is not a complete UK register, a jurisdiction league table, a migration ranking or proof of a direct move.", "licence_note": "The CAA full G-INFO download is a paid, licensed product and is not copied or redistributed. This output uses the public recent-changes web page and omits registered-owner names. FAA releasable registry files are retained from the official daily archive.", "sources": [ { "name": "FAA Releasable Aircraft Database", "url": "https://www.faa.gov/licenses_certificates/aircraft_certification/aircraft_registry/releasable_aircraft_download", "cadence": "Daily at 11:30pm Central Time" }, { "name": "CAA G-INFO recent changes", "url": "https://www.caa.co.uk/aircraft-register/g-info/recent-changes-to-the-uk-aircraft-register/", "cadence": "Public page updated in fortnightly windows" }, { "name": "CAA G-INFO download and conditions", "url": "https://www.caa.co.uk/aircraft-register/g-info/g-info-download/", "cadence": "Paid full product produced monthly" } ] } }, "source_tables": [ "_gdb_registration_history", "_gdb_airframe" ], "requested_fields": "CAA action window; UK registration; aircraft type; serial number where public; transfer destination; exact FAA serial/model review", "still_missing": "A narrow official CAA recent-changes and FAA archive baseline is live. The public CAA page is not the full UK register; a league or migration ranking still requires licensed complete registries, repeated snapshots and approved jurisdiction rules.", "collection_plan": "Parse the four public CAA windows; omit owner names; classify only explicit jet types; require exact serial and compatible manufacturer/model for an FAA historical overlap", "frequency": "Fortnightly CAA page; daily FAA archive", "first_output_rule": "Publish the narrow recent-action and technical-overlap baseline only; no league or migration claim without complete licensed registry histories", "planned_external_source": "UK CAA G-INFO public recent changes plus FAA current and deregistered releasable files", "planned_source_url": "https://www.caa.co.uk/aircraft-register/g-info/recent-changes-to-the-uk-aircraft-register/" }, { "idea_number": 18, "slug": "closer-to-a-runway-than-an-er", "idea": "Closer to a Runway Than an ER", "worker_url": "https://sprinkle-pr-data-seeds.alexdunsdonagent.workers.dev/jobs/18", "seed_status": "first output live — monthly source check", "generated_on": "2026-07-31", "current_record_summary": "1,845 qualifying municipalities; 4,414 located CMS emergency hospitals; 3,878 qualifying public airports", "current_metrics": { "airports": { "runway_rows": 25589, "open_runways": 24945, "aerodrome_rows": 71957, "operational_aerodromes": 71957 }, "job_18_output": { "generated_on": "2026-07-30", "cms_source_modified": "2026-04-28", "cms_source_released": "2026-05-13", "cms_registered_hospitals": 5432, "emergency_hospitals": 4498, "census_batch_matches": 3832, "census_single_address_matches": 33, "municipality_centroid_hospitals": 549, "geocoded_emergency_hospitals": 4414, "geocode_match_rate": 0.9813, "municipalities_compared": 16241, "qualifying_public_airports": 3878, "municipalities_closer_to_runway": 1845, "minimum_published_advantage_miles": 5, "runway_rule": "Nearest operational US public fixed-wing airport with a non-water, non-ice runway at least 800m long and 15m wide; unknown surface retained and disclosed.", "cms_landing_page": "https://data.cms.gov/provider-data/dataset/xubh-q36u", "census_geocoder_documentation": "https://www.census.gov/programs-surveys/geography/technical-documentation/complete-technical-documentation/census-geocoder.html" } }, "source_tables": [ "_gdb_aerodrome", "_gdb_runway" ], "requested_fields": "Hospital ID; address; emergency-services flag; coordinates; municipality coordinates; runway distance", "still_missing": "The first straight-line screening output is live. Road/ferry travel times and facilities outside CMS still require local verification before publication.", "collection_plan": "Download the CSV/API data; keep hospitals with Emergency Services = Yes; geocode/validate; calculate nearest ER and runway", "frequency": "Monthly or when CMS changes", "first_output_rule": "Publish after spot-checking the most extreme distances", "planned_external_source": "CMS Hospital General Information plus Sprinkle municipality/runway data", "planned_source_url": "https://data.cms.gov/provider-data/dataset/xubh-q36u" }, { "idea_number": 19, "slug": "sprinkle-ga-market-report", "idea": "Sprinkle GA Market Report", "worker_url": "https://sprinkle-pr-data-seeds.alexdunsdonagent.workers.dev/jobs/19", "seed_status": "current market edition live — monthly", "generated_on": "2026-07-31", "current_record_summary": "436,176 active airframes; 2,056 active priced listings; 2,379,212 recent tracked legs", "current_metrics": { "dealer_listings": { "total_rows": 13904, "active_rows": 6801, "active_priced_rows": 2033, "latest_active_posted_at": "2026-06-01T15:46:08.701+00:00", "active_priced_currencies": 5, "earliest_active_posted_at": "2025-10-10T15:02:52.208+00:00" }, "portal_listings": { "sold_rows": 6, "total_rows": 51, "active_rows": 35, "active_priced_rows": 23 }, "demand": { "wanted_rows": 14, "saved_search_rows": 3, "active_wanted_rows": 8 }, "flights": { "leg_rows": 4581271, "latest_leg_at": "2026-07-20T14:29:57.418+00:00", "earliest_leg_at": "2026-05-05T20:04:01+00:00", "tracked_aircraft": 88159, "complete_leg_rows": 4523982 }, "job_19_output": { "generated_on": "2026-07-30", "edition": "2026-07", "segments": 25, "active_airframes": 436176, "classified_airframes": 297589, "active_priced_listings": 2056, "classified_listings": 1061, "recent_flight_legs": 2379212, "flight_window_start": "2026-06-20T14:29:57.418+00:00", "flight_window_end": "2026-07-20T14:29:57.418+00:00", "buyer_demand": { "saved_searches": 3, "wanted_records": 14, "active_wanted_records": 8 }, "limitations": [ "Asking prices are not verified completed-sale prices.", "Buyer-demand records are currently a small first-party sample.", "Flight activity reflects the latest 30-day window available in Sprinkle, which may lag the report date.", "Year-over-year claims require at least 12 monthly snapshots." ] } }, "source_tables": [ "_gdb_dealer_listing", "_gdb_model", "_gdb_family", "_gdb_category", "_gdb_manufacturer", "_gdb_mkt_aircraft_listing", "_gdb_mkt_listing_inquiry", "_gdb_mkt_aircraft_wanted", "_gdb_mkt_saved_search", "flight_raw_legs" ], "requested_fields": "Listings; asking prices; inventory; model fleet; flight activity; buyer demand; snapshot date", "still_missing": "The live monthly report is complete; year-over-year claims must wait for 12 comparable editions.", "collection_plan": "Save monthly market snapshots; calculate inventory, asking-price medians, activity and qualified demand by segment", "frequency": "Daily collection; monthly snapshot; annual report", "first_output_rule": "Publish a current-market edition now; reserve year-over-year claims for 12 snapshots", "planned_external_source": "Sprinkle listings, aircraft, flights and consented buyer-intent events", "planned_source_url": null }, { "idea_number": 21, "slug": "fastest-selling-aircraft", "idea": "Fastest-Selling Aircraft", "worker_url": "https://sprinkle-pr-data-seeds.alexdunsdonagent.workers.dev/jobs/21", "seed_status": "collector live — daily history", "generated_on": "2026-07-31", "current_record_summary": "2 of 90 observed days; 1 of 12 registry snapshots; 13,955 current collector rows; 0 later change events; history building", "current_metrics": { "dealer_listings": { "total_rows": 13904, "active_rows": 6801, "active_priced_rows": 2033, "latest_active_posted_at": "2026-06-01T15:46:08.701+00:00", "active_priced_currencies": 5, "earliest_active_posted_at": "2025-10-10T15:02:52.208+00:00" }, "portal_listings": { "sold_rows": 6, "total_rows": 51, "active_rows": 35, "active_priced_rows": 23 }, "listing_metrics": { "snapshot_rows": 19, "latest_snapshot_date": "2026-07-31", "earliest_snapshot_date": "2026-07-03" }, "registration_history": { "rows": 399135, "aircraft": 399133, "latest_valid_from": "2026-05-01T13:28:54.397007+00:00", "extra_history_rows": 2, "earliest_valid_from": "2026-05-01T08:09:06.587513+00:00" }, "history_collector_maturity": { "data_generated_on": "2026-07-31", "data_checked_at": "2026-07-31T19:18:42Z", "idea_number": "21", "idea": "Fastest-Selling Aircraft", "source_collector": "Daily listing-state history", "cadence": "Daily · 05:15 UTC; monthly registry validation", "earliest_snapshot": "2026-07-30", "latest_snapshot": "2026-07-31", "distinct_snapshots": "2", "observed_days": "2", "observed_months": "1", "current_rows": "13955", "baseline_events": "13955", "change_events": "0", "current_sold_status_rows": "393", "event_detail": "13,955 first-observed events; 0 later change events", "source_tables": "Cloudflare listing_tracker_runs/current/events; Sprinkle listings; monthly FAA registration history", "required_gate": "At least 90 observed days, enough confirmed sales per model and later registry validation", "gate_progress": "2 of 90 observed days; 1 of 12 registry snapshots", "earliest_plausible_eligibility": "2026-10-28 (conditional)", "eligibility_state": "history_building", "exact_blocker": "No listing has yet changed state after the baseline, and the single FAA snapshot cannot validate a later owner change. Pre-existing sold labels are not observed sales durations." } }, "source_tables": [ "_gdb_dealer_listing", "_gdb_model", "_gdb_family", "_gdb_category", "_gdb_manufacturer", "_gdb_mkt_aircraft_listing", "_gdb_mkt_listing_metrics_daily", "_gdb_registration_history" ], "requested_fields": "Listing ID; serial number; first seen; sold date; withdrawn/relisted status; later owner change", "still_missing": "Two of 90 listing days and one of 12 FAA snapshots exist, with zero later listing-state changes. The conditional time gate is 28 October 2026; confirmed sales and later owner changes are also required.", "collection_plan": "Track listing states daily; confirm likely sales with sold flags and later owner changes; calculate median days to sale", "frequency": "Daily listings; monthly registry", "first_output_rule": "Publish only models with enough confirmed sales", "planned_external_source": "Sprinkle listing snapshots and FAA registry snapshots", "planned_source_url": "https://registry.faa.gov/database/" }, { "idea_number": 26, "slug": "plane-costs-less-than-a-house", "idea": "Plane Costs Less Than a House", "worker_url": "https://sprinkle-pr-data-seeds.alexdunsdonagent.workers.dev/jobs/26", "seed_status": "first US output live — monthly listings", "generated_on": "2026-07-31", "current_record_summary": "487 qualifying active listings across 41 states; 1,053 listings resolved to a Census state", "current_metrics": { "dealer_listings": { "total_rows": 13904, "active_rows": 6801, "active_priced_rows": 2033, "latest_active_posted_at": "2026-06-01T15:46:08.701+00:00", "active_priced_currencies": 5, "earliest_active_posted_at": "2025-10-10T15:02:52.208+00:00" }, "portal_listings": { "sold_rows": 6, "total_rows": 51, "active_rows": 35, "active_priced_rows": 23 }, "job_26_output": { "generated_on": "2026-07-30", "active_dealer_listings_seen": 2033, "located_usd_listings_above_10000": 1053, "census_state_matches": 1053, "qualifying_listings": 487, "states_represented": 41, "house_value_source": "2024 ACS 1-year estimate, table B25077", "house_value_source_url": "https://www2.census.gov/programs-surveys/acs/summary_file/2024/table-based-SF/data/1YRData/acsdt1y2024-b25077.dat", "comparison_rule": "Active US dealer listing in USD, asking price at least $10,000 and below the ACS state median owner-occupied home value." } }, "source_tables": [ "_gdb_dealer_listing", "_gdb_model", "_gdb_family", "_gdb_category", "_gdb_manufacturer", "_gdb_mkt_aircraft_listing" ], "requested_fields": "Aircraft asking price; coordinates; Census state; state median home value; estimate year; currency", "still_missing": "The first US state-level output is live. Local house values, completed aircraft sale prices and non-US editions remain outside this comparison.", "collection_plan": "Keep active US dollar listings; resolve coordinates to Census state; verify city/state agreement; exclude sold/pending wording; compare asking price with the ACS state median owner-occupied home value", "frequency": "Monthly listings; annual ACS benchmark", "first_output_rule": "Publish the US state-level comparison separately; verify every source listing before citation", "planned_external_source": "US Census ACS table B25077 plus Sprinkle dealer listings; HM Land Registry reserved for a separate UK edition", "planned_source_url": "https://www2.census.gov/programs-surveys/acs/summary_file/2024/table-based-SF/data/1YRData/acsdt1y2024-b25077.dat" }, { "idea_number": 27, "slug": "hidden-gem-airfield-awards", "idea": "Hidden Gem Airfield Awards", "worker_url": "https://sprinkle-pr-data-seeds.alexdunsdonagent.workers.dev/jobs/27", "seed_status": "first finalist shortlist live — monthly; winners editorial", "generated_on": "2026-07-31", "current_record_summary": "157 finalist airfields across 53 jurisdictions; 0 editorially approved winners", "current_metrics": { "airports": { "runway_rows": 25589, "open_runways": 24945, "aerodrome_rows": 71957, "operational_aerodromes": 71957 }, "flights": { "leg_rows": 4581271, "latest_leg_at": "2026-07-20T14:29:57.418+00:00", "earliest_leg_at": "2026-05-05T20:04:01+00:00", "tracked_aircraft": 88159, "complete_leg_rows": 4523982 }, "job_27_output": { "generated_on": "2026-07-31", "finalist_airfields": 157, "represented_jurisdictions": 53, "eligible_airfields_before_state_limit": 1560, "approved_winners": 0, "tracking_start": "2026-05-05", "tracking_end": "2026-07-20", "rules": { "eligibility": [ "Open, public-use airport in the United States in the FAA NASR cycle effective 9 July 2026", "At least one asphalt or concrete runway of 3,000 feet or longer that is not reported as poor or failed", "FAA-listed fuel plus at least two of repair, other pilot services, storage or runway lighting", "More than zero Sprinkle-tracked arrivals and departures in the stated activity window" ], "score": "10 points maximum: paved runway length 1–3; fuel 1; repair 1; other pilot services 1; storage 1; runway lighting 1; observed activity band 0–2 (1–50 movements = 2, 51–250 = 1, more than 250 = 0).", "state_limit": "The top 3 screening scores per state or US jurisdiction are retained. Ties break on fewer tracked movements, then longer paved runway, then airport name.", "approval": "The screening score produces finalists only. No airport is a winner unless an editor changes approved_winner after direct verification and records the decision in review_notes." }, "sources": [ { "name": "FAA National Airspace System Resources (NASR), airport and runway records", "url": "https://nfdc.faa.gov/webContent/28DaySub/extra/09_Jul_2026_APT_CSV.zip", "effective_on": "2026-07-09" }, { "name": "Sprinkle flight_raw_legs airport movement cache", "coverage_start": "2026-05-05", "coverage_end": "2026-07-20", "refreshed_at": "2026-07-31T10:05:30Z" } ], "caveats": [ "Sprinkle tracking is not a complete census of general-aviation movements; a low count may reflect coverage rather than low real-world use.", "FAA facility fields can be missing or stale and must be confirmed with each airport.", "The score does not measure scenery, hospitality, food, access, safety, service quality or community value.", "The shortlist is evidence for editorial review, not an automatic award or endorsement." ] } }, "source_tables": [ "_gdb_aerodrome", "_gdb_runway", "flight_raw_legs" ], "requested_fields": "Airport facilities; runway quality; access; flight activity; scoring fields; review decision", "still_missing": "The first evidence-based finalist shortlist is live. Qualitative checks and explicit editorial approval are still required before naming any winner.", "collection_plan": "Save monthly airport activity; calculate the approved feature/activity score; output finalists for manual approval", "frequency": "Weekly collection; annual awards", "first_output_rule": "No automatic winner: every state result requires editorial approval", "planned_external_source": "Sprinkle airport, runway and accumulated flight data", "planned_source_url": null }, { "idea_number": 28, "slug": "great-aircraft-migration", "idea": "Great Aircraft Migration", "worker_url": "https://sprinkle-pr-data-seeds.alexdunsdonagent.workers.dev/jobs/28", "seed_status": "collector live — monthly history", "generated_on": "2026-07-31", "current_record_summary": "1 monthly FAA source; second approved registry not live; 308,578 current collector rows; 0 later change events; external source blocked", "current_metrics": { "registration_history": { "rows": 399135, "aircraft": 399133, "latest_valid_from": "2026-05-01T13:28:54.397007+00:00", "extra_history_rows": 2, "earliest_valid_from": "2026-05-01T08:09:06.587513+00:00" }, "airframes": { "rows": 695125, "with_year": 424142, "with_model": 628418, "active_rows": 436176, "with_country": 456484 }, "history_collector_maturity": { "data_generated_on": "2026-07-31", "data_checked_at": "2026-07-31T19:18:42Z", "idea_number": "28", "idea": "Great Aircraft Migration", "source_collector": "Monthly FAA registration history", "cadence": "Monthly · first day at 05:30 UTC", "earliest_snapshot": "2026-07-01", "latest_snapshot": "2026-07-01", "distinct_snapshots": "1", "observed_days": "1", "observed_months": "1", "current_rows": "308578", "baseline_events": "308578", "change_events": "0", "current_sold_status_rows": "", "event_detail": "0 owner, state, model or register-exit changes", "source_tables": "Cloudflare registration_tracker_runs; Sprinkle _gdb_registration_history; _gdb_airframe", "required_gate": "Two approved national registry histories and confirmed serial-number matches across registers", "gate_progress": "1 monthly FAA source; second approved registry not live", "earliest_plausible_eligibility": "Unknown", "eligibility_state": "external_source_blocked", "exact_blocker": "The collector has only the FAA monthly baseline. No second approved national registry history is available, so cross-register movement cannot be observed or dated." } }, "source_tables": [ "_gdb_registration_history", "_gdb_airframe" ], "requested_fields": "Serial number; registry country; registration mark; owner; entry/exit snapshot date", "still_missing": "One monthly FAA baseline exists. The public CAA recent-changes page is not a complete second registry history, so cross-register eligibility remains unknown.", "collection_plan": "Save complete dated snapshots for each approved registry; match serial numbers; distinguish confirmed moves from unknown exits", "frequency": "Monthly", "first_output_rule": "Start with two countries and publish only confirmed cross-register matches", "planned_external_source": "Official national aircraft registry downloads; start with FAA and UK CAA G-INFO", "planned_source_url": "https://www.caa.co.uk/aircraft-register/g-info/" }, { "idea_number": 29, "slug": "orphan-fleet", "idea": "Orphan Fleet", "worker_url": "https://sprinkle-pr-data-seeds.alexdunsdonagent.workers.dev/jobs/29", "seed_status": "manufacturer evidence queue live — status review pending", "generated_on": "2026-07-31", "current_record_summary": "200 manufacturer review candidates covering 41,620 active aircraft; 0 approved orphan manufacturers", "current_metrics": { "airframes": { "rows": 695125, "with_year": 424142, "with_model": 628418, "active_rows": 436176, "with_country": 456484 }, "job_29_output": { "generated_on": "2026-07-31", "review_candidates": 200, "active_aircraft_in_candidate_fleets": 41620, "approved_orphan_manufacturers": 0, "minimum_active_aircraft": 25, "minimum_aircraft_with_year": 10, "latest_recorded_year_cutoff": 2016, "methodology": "Established OEMs with at least 25 active airframes, at least 10 plausible manufacture years and no recorded build year in the last decade are placed into a manual review queue.", "caveat": "The absence of recent manufacture years does not prove that a manufacturer is defunct, unsupported or an orphan fleet. Every candidate requires a cited company-status and successor review." } }, "source_tables": [ "_gdb_airframe" ], "requested_fields": "Manufacturer; model; active aircraft count; ceased year; successor; evidence source", "still_missing": "A 200-manufacturer evidence queue is live. No manufacturer is approved as defunct or unsupported until a cited company-status, successor and support review is completed.", "collection_plan": "Refresh the evidence queue from active fleet counts and manufacture-year coverage; add cited defunct, successor and support decisions manually", "frequency": "Quarterly review; monthly aircraft count", "first_output_rule": "Publish the unapproved research queue now; make orphan-fleet claims only for manufacturers with a cited and approved status", "planned_external_source": "Sprinkle aircraft/manufacturer data plus an approved defunct-manufacturer reference list", "planned_source_url": null }, { "idea_number": 30, "slug": "in-the-path-of-the-storm", "idea": "In the Path of the Storm", "worker_url": "https://sprinkle-pr-data-seeds.alexdunsdonagent.workers.dev/jobs/30", "seed_status": "first historical exposure screening live — weekly activity; annual tracks", "generated_on": "2026-07-31", "current_record_summary": "3,994 aircraft passed the conservative base inference; 267 at airports within 100nm of a 2006–2025 hurricane track; 17 reportable airports", "current_metrics": { "flights": { "leg_rows": 4581271, "latest_leg_at": "2026-07-20T14:29:57.418+00:00", "earliest_leg_at": "2026-05-05T20:04:01+00:00", "tracked_aircraft": 88159, "complete_leg_rows": 4523982 }, "airports": { "runway_rows": 25589, "open_runways": 24945, "aerodrome_rows": 71957, "operational_aerodromes": 71957 }, "faa": { "total_rows": 314707, "valid_rows": 308578, "valid_with_year": 242965, "valid_with_owner": 305189, "valid_state_codes": 58, "valid_with_county": 304424, "valid_owner_mentions_trust": 13137 }, "job_30_output": { "generated_on": "2026-07-31", "observation_start": "2026-05-07", "observation_end": "2026-07-20", "conservative_observed_base_aircraft": 3994, "unique_inferred_airports": 288, "aircraft_at_airports_with_hurricane_proximity": 267, "reportable_airports": 17, "atlantic_and_pacific_hurricanes_reviewed": 335, "hurricane_history_start_year": 2006, "hurricane_history_end_year": 2025, "proximity_threshold_nm": 100, "base_inference_rule": "At least 30 complete legs across 30 observed days; at least 20 endpoints at the leading airport; at least 40% of all endpoints; and at least 1.5 times the second airport's visits.", "caveat": "An inferred airport is not a declared or permanent base. Historical track proximity is not a forecast, damage estimate, evacuation instruction or claim that an aircraft was present during any storm." } }, "source_tables": [ "flight_raw_legs", "_gdb_aerodrome", "_gdb_runway", "stg_faa_v2_master" ], "requested_fields": "Registration; conservatively inferred airport; leg and endpoint counts; observation period; nearby hurricane count; closest and latest hurricane", "still_missing": "The historical exposure screening dataset is live. It remains an observed-period base inference, not a permanent-base declaration, current storm forecast or damage model.", "collection_plan": "Refresh both official HURDAT2 files annually; infer an observed base only after the fixed leg, duration, share and margin gates; compare airport coordinates with hurricane-strength tracks from the latest 20 completed seasons", "frequency": "Weekly flight accumulation; annual HURDAT2 refresh", "first_output_rule": "Publish historical exposure screening only; never describe an inferred airport as a permanent base or the historical result as a forecast", "planned_external_source": "NHC Atlantic and East/Central Pacific HURDAT2 plus accumulated Sprinkle flight legs", "planned_source_url": "https://www.nhc.noaa.gov/data/" }, { "idea_number": 31, "slug": "student-pilots-pensioner-planes", "idea": "Student Pilots, Pensioner Planes", "worker_url": "https://sprinkle-pr-data-seeds.alexdunsdonagent.workers.dev/jobs/31", "seed_status": "official school baseline and identity review live — monthly; fleet-age ranking withheld", "generated_on": "2026-07-31", "current_record_summary": "714 official FAA Part 141 school locations; 4 narrow Sprinkle identity candidates; 0 approved matches; 0 fleet-age rows published", "current_metrics": { "operators": { "operator_rows": 6160, "active_operator_rows": 1253, "aircraft_operator_rows": 52910, "current_aircraft_operator_rows": 52910 }, "airframes": { "rows": 695125, "with_year": 424142, "with_model": 628418, "active_rows": 436176, "with_country": 456484 }, "job_31_output": { "generated_on": "2026-07-31", "faa_source_observed_on": "2026-07-31", "faa_dashboard_data_updated_on": "2026-07-27", "faa_us_part141_school_locations": 714, "narrow_sprinkle_raw_name_variants": 6, "normalized_sprinkle_candidates": 4, "narrow_sprinkle_assignment_rows": 26, "narrow_sprinkle_distinct_aircraft": 26, "linked_operator_rows": 0, "approved_faa_school_matches": 0, "published_fleet_age_rows": 0, "source": "FAA AVInfo Find a Facility dashboard plus Sprinkle v2 _gdb_airframe_operator_history and _gdb_airframe", "refresh_cadence": "Monthly FAA identity review; regenerate from Sprinkle on each data-room publish", "methodology": "Observe the current official US Part 141 pilot-school directory; select a deliberately narrow Sprinkle queue with literal TRAINING or FLIGHT ACADEMY labels; normalize punctuation, accents and limited corporate suffixes; require US jurisdiction, a linked Sprinkle operator identity and manual exact school/location evidence before approval.", "caveat": "The current Sprinkle candidates are raw Brazil-scoped assignment labels with no linked operator UUID. None can be matched to the US FAA Part 141 directory, so no school fleet-age result or ranking is published.", "official_source_export_limit": "The FAA dashboard displayed 714 US Part 141 locations and a 27 July 2026 data date, but its guest crosstab control was disabled. Cached official page/dashboard responses support the source check; this release does not republish school contact records." } }, "source_tables": [ "_gdb_operator", "_gdb_airframe_operator_history", "_gdb_airframe" ], "requested_fields": "Official FAA school count and source date; narrow school-like assignment labels; aircraft country; linked operator identity; approval flags", "still_missing": "The official FAA Part 141 school baseline and a narrow Sprinkle identity queue are live. No current candidate has a US-scoped linked operator identity, so exact school-to-aircraft evidence and manual approval are still required before any fleet-age result.", "collection_plan": "Record the official US Part 141 baseline; normalize a narrow identity-review queue; require US scope, linked operator identity and exact manual school/location evidence before any age calculation", "frequency": "Monthly identity review", "first_output_rule": "Publish the identity review now; publish no school fleet-age result until every identity gate passes", "planned_external_source": "FAA AVInfo Find a Facility dashboard plus Sprinkle operator history", "planned_source_url": "https://www.faa.gov/av-info/facility-dashboard" }, { "idea_number": 33, "slug": "private-jet-capitals", "idea": "Private Jet Capitals", "worker_url": "https://sprinkle-pr-data-seeds.alexdunsdonagent.workers.dev/jobs/33", "seed_status": "first registered-address output live — annual", "generated_on": "2026-07-31", "current_record_summary": "119 qualifying cities across 36 states; 5,081 business-jet registrations", "current_metrics": { "faa": { "total_rows": 314707, "valid_rows": 308578, "valid_with_year": 242965, "valid_with_owner": 305189, "valid_state_codes": 58, "valid_with_county": 304424, "valid_owner_mentions_trust": 13137 }, "flights": { "leg_rows": 4581271, "latest_leg_at": "2026-07-20T14:29:57.418+00:00", "earliest_leg_at": "2026-05-05T20:04:01+00:00", "tracked_aircraft": 88159, "complete_leg_rows": 4523982 }, "job_33_output": { "generated_on": "2026-07-31", "qualifying_cities": 119, "represented_states": 36, "business_jet_registrations_in_qualifying_cities": 5081, "population_floor": 10000, "jet_floor": 10, "distinct_owner_floor": 5, "methodology": "Valid FAA registrations mapped to Sprinkle models categorised FIXED_WING / BUSINESS_JET, grouped by registered-owner city and divided by Sprinkle municipality population.", "caveat": "Registered-owner address is not the aircraft's physical or operating base." } }, "source_tables": [ "stg_faa_v2_master", "flight_raw_legs" ], "requested_fields": "Valid FAA registration; Sprinkle business-jet category and size segment; registered-owner city/state; municipality population; distinct owners; largest-owner concentration", "still_missing": "The first registered-address city ranking is live. Physical-base and metro-area claims still require longer flight activity and boundary work.", "collection_plan": "Run the reviewed database function; group valid business-jet registrations by registered-owner municipality; calculate jets per 100,000 residents and owner concentration", "frequency": "Annual FAA/municipality refresh", "first_output_rule": "Publish as a registered-address city ranking; exclude small samples and never describe it as aircraft physical-base data", "planned_external_source": "FAA registry staging, Sprinkle aircraft-model taxonomy and Sprinkle municipality population", "planned_source_url": "https://www.faa.gov/licenses_certificates/aircraft_certification/aircraft_registry/releasable_aircraft_download" }, { "idea_number": 34, "slug": "ghost-airports", "idea": "Ghost Airports", "worker_url": "https://sprinkle-pr-data-seeds.alexdunsdonagent.workers.dev/jobs/34", "seed_status": "first conservative candidate output live — annual", "generated_on": "2026-07-31", "current_record_summary": "13 conservative reporting candidates across 7 states; $35.0m in FY2025 grants", "current_metrics": { "airports": { "runway_rows": 25589, "open_runways": 24945, "aerodrome_rows": 71957, "operational_aerodromes": 71957 }, "flights": { "leg_rows": 4581271, "latest_leg_at": "2026-07-20T14:29:57.418+00:00", "earliest_leg_at": "2026-05-05T20:04:01+00:00", "tracked_aircraft": 88159, "complete_leg_rows": 4523982 }, "job_34_output": { "generated_on": "2026-07-31", "candidate_airports": 13, "represented_states": 7, "fy2025_grants_to_candidates": 34964161, "tracking_start": "2026-05-05", "tracking_end": "2026-07-20", "thresholds": { "minimumGrant": 500000, "maximumBasedAircraft": 10, "maximumAnnualOperations": 1000, "maximumTrackedMovements": 5 }, "methodology": "Open public-use airports receiving at least $500,000 in FY2025 AIP grants, with no more than 10 FY2025 FAA TAF based aircraft, 1,000 FY2025 FAA TAF operations and five Sprinkle-tracked movements in the stated window.", "caveat": "These are reporting candidates, not proof that an airport is unused. FAA TAF values are planning data, and Sprinkle tracking is incomplete for general aviation." } }, "source_tables": [ "_gdb_aerodrome", "_gdb_runway", "flight_raw_legs" ], "requested_fields": "FAA location and ICAO identifiers; FY2025 grants; FY2025 TAF based-aircraft and operations values; tracked arrivals/departures; fixed period", "still_missing": "A conservative reporting shortlist is live. Airport, FAA and local-purpose verification is still required before any claim that a facility is unused or wasteful.", "collection_plan": "Aggregate grants; keep open public-use NASR airports; join the TAF baseline scenario; compare with the cached 4.58 million-leg Sprinkle tracking window; exclude missing FAA values", "frequency": "Annual AIP/TAF; refresh tracked window before each edition", "first_output_rule": "Publish only confident identifier matches passing all four thresholds; call them reporting candidates and require airport/FAA verification", "planned_external_source": "FAA AIP Grant Histories, FAA 2025 Terminal Area Forecast, FAA NASR and Sprinkle flight activity", "planned_source_url": "https://www.faa.gov/airports/aip/grant_histories" }, { "idea_number": 37, "slug": "60-000-ride", "idea": "$60,000 Ride", "worker_url": "https://sprinkle-pr-data-seeds.alexdunsdonagent.workers.dev/jobs/37", "seed_status": "official payment and industry baseline live — annual", "generated_on": "2026-07-31", "current_record_summary": "16 strict-name Part 135 operator candidates; 180 of 184 FAA aircraft matched to Sprinkle; 109 CMS payment benchmarks; 0 approved providers", "current_metrics": { "operators": { "operator_rows": 6160, "active_operator_rows": 1253, "aircraft_operator_rows": 52910, "current_aircraft_operator_rows": 52910 }, "airframes": { "rows": 695125, "with_year": 424142, "with_model": 628418, "active_rows": 436176, "with_country": 456484 }, "job_37_output": { "generated_on": "2026-07-31", "cms_schedule_year": 2026, "cms_locality_rows": 109, "benchmark_distance_miles": 100, "latest_faa_reporting_year": 2022, "latest_faa_reporting_operators": 65, "latest_faa_reported_helicopters": 1283, "latest_faa_reported_patients": 364079, "approved_operator_assignments": 0, "sprinkle_explicit_name_current_links": 2, "strict_name_operator_candidates": 16, "faa_strict_name_aircraft_rows": 185, "faa_valid_n_number_rows": 184, "sprinkle_matched_aircraft": 180, "sprinkle_active_aircraft": 179, "sprinkle_aircraft_with_year": 168, "fixed_wing_urban_100_mile_median_usd": 4982.72, "rotary_wing_urban_100_mile_median_usd": 7441.9, "rotary_wing_rural_100_mile_median_usd": 11163.35, "rotary_wing_rural_100_mile_min_usd": 10644.78, "rotary_wing_rural_100_mile_max_usd": 12607.91, "methodology": "A 100-mile Medicare payment benchmark equals the CMS locality-specific air base rate plus 100 times the corresponding air mileage rate. FAA annual figures are transcribed from the agency's reports to Congress.", "caveat": "These are Medicare payment-schedule benchmarks, not provider charges, negotiated insurance payments, patient bills or estimates of an individual person's liability. No Sprinkle operator is classified as an approved air-ambulance provider." } }, "source_tables": [ "_gdb_operator", "_gdb_airframe_operator_history", "_gdb_airframe" ], "requested_fields": "CMS air-ambulance base and mileage rates; carrier/locality; fixed example distance; FAA annual helicopters, bases, hours and patients", "still_missing": "The official payment and industry baseline is live. Provider charges, insurer payments, patient liability and verified operator-level fleet assignments are not available in the current source set.", "collection_plan": "Import the annual CMS schedule; calculate a fixed-distance payment benchmark for every complete locality; append FAA national annual totals; keep charges, insurer payments and patient liability separate", "frequency": "Annual, when official source files change", "first_output_rule": "Publish the official-data baseline now; do not call a payment benchmark a provider charge or patient bill, and do not publish operator identities without verified classification", "planned_external_source": "CMS Ambulance Fee Schedule Public Use File and FAA helicopter-air-ambulance reports to Congress", "planned_source_url": "https://www.cms.gov/medicare/payment/fee-schedules/ambulance/ambulance-fee-schedule-public-use-files" } ] }