Skip to content

Cancelled registrations · 50

Query with SQL

SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_state = 'CO' AND d.registrant_city = 'BRIGHTON' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
  WHERE d.registrant_state = 'CO' AND d.registrant_city = 'BRIGHTON'
  ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
WHERE d.registrant_state = 'CO' AND d.registrant_city = 'BRIGHTON'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N120BDVans RV-12IS · S/N 121401Cancelled Sep 9, 2026 · Drennan Bill R N801GDDefelic Dan ZENITH CH-801 · S/N 8-4152Cancelled Jul 28, 2023 · Exported to Canada · Built 2001 · Jesse Thomas A N5337VChristen Industries PITTS S-2B · S/N 5074Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Edwards Thomas E N9517PCameron Balloons US V-77 · S/N 5631Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Bousselaire Maria C N9086UBalloon Works FIREFLY 7B-15 · S/N F7B-322Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 1991 · Riehl Frank N7640ACessna 180 · S/N 32537Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 1956 · Bushmaster Communications Co Inc N113KWChampion 7ECA · S/N 660Cancelled May 29, 2020 · Registration expired, pending cancellation · Built 1969 · Wells Mary Ann N1KWWells SUPER SKYBOLT I · S/N 001Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Built 1972 · Wells Mary Ann N63010Lithuanian Factory Of LAK-12 · S/N 6228Cancelled Sep 6, 2019 · Sale reported, canceled N32819Balloon Works FIREFLY 8B-15 · S/N F8B-475Cancelled Feb 23, 2019 · Registration expired, pending cancellation · Built 1996 · Riehl Frank J DBA N4364ZPiper PA-18-150 · S/N 18-8684Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Built 1968 · Hub Salvage Ltd N5JWLieber PITTS S-1 · S/N 557HCancelled Mar 30, 2018 · Registration expired, pending cancellation · Built 1973 · Wright Robert E N4DNPiper PA-30 · S/N 30-1228Cancelled Mar 16, 2018 · Registration expired, pending cancellation · Built 1966 · Wells Mary Ann N8441Brisson SCORPION TOO · S/N JAB1538Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 1974 · Wright Robert E N8504PPiper PA-24-400 · S/N 26-84Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 1964 · Adams Eldon M N6552LGrumman American Avn. AA-5 · S/N AA5-0652Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1974 · Alexander Thomas E N3339EAeronca 7AC · S/N 7AC-6789Cancelled Mar 2, 2018 · Registration expired, pending cancellation · Built 1947 · Fling Gary L N82828Piper PA-28RT-201T · S/N 28R-8131015Cancelled Feb 23, 2018 · Registration expired, pending cancellation · Built 1980 · Tefft Wade H N71526Luscombe 8A · S/N 2953Cancelled Feb 21, 2018 · Registration expired, pending cancellation · Built 1946 · Rennick Alan N319SBQuad City Challenger CHALLENGER I · S/N 0892-0393Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Built 1992 · Challenger Aircraft LLC N3716BBalloon Works FIREFLY 7 · S/N F7-226Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Riehl Frank J DBA N2703PPiper PA-22-150 · S/N 22-3009Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1955 · Van Blarcom Karry J N55857Airborne WINDSPORT EDGE · S/N 582-560Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 2000 · Wenzel Jonathon N3826ASchweizer SGS 1-26A · S/N 74Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Built 1959 · Pier Martin S N747HMMathewson H PITTS S1R · S/N 2001MMCancelled May 14, 2015 · Sale reported, canceled N74198Balloon Works FIREFLY 8B · S/N F8B-046Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Morris Michael E N9648ZCallair A-9 · S/N 1038Cancelled Dec 9, 2014 · Revoked, pending cancellation · Built 1963 · Speer George N68409Boeing A75 · S/N 75-7790Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1943 · Heckendorf Robert W N6293CPiper PA-18-125 · S/N 18-951Cancelled Aug 19, 2013 · Registration expired, pending cancellation · Built 1957 · Gurley Lyle G N9308FHughes 269B · S/N 123-0010Cancelled Aug 1, 2013 · Registration expired, pending cancellation · Built 1964 · Gurley Gordon B DBA N7002DEagle Balloons C-7 · S/N E82732Cancelled Jun 10, 2013 · Sale reported, canceled · Built 1982 N3772GBalloon Works FIREFLY 6B · S/N F6B-012Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Built 1984 · Riehl Frank J N4106MPiper PA-12 · S/N 12-3002Cancelled Apr 17, 2013 · Registration expired, pending cancellation · Built 1947 · Brown Rodney D N7688BBellanca 14-19-2 · S/N 4039Cancelled Feb 26, 2013 · Sale reported, canceled · Built 1957 N200JSBell 206B · S/N 344Cancelled Dec 18, 2012 · Registration expired, pending cancellation · Built 1969 · Gurley Lyle G N3227BPiper PA-22-135 · S/N 22-2055Cancelled Nov 6, 2012 · Registration expired, pending cancellation · Built 1954 · Remmenga R Richard N9598FHughes 269C · S/N 740329Cancelled Jul 19, 2011 · Expired dealer · Built 1974 · Gurley Gordon B DBA N9611FHughes 269C · S/N 700018Cancelled Jul 19, 2011 · Expired dealer · Built 1970 · Gurley G B DBA N76294Cessna 140 · S/N 10708Cancelled Jun 30, 2011 · Expired dealer · Built 1949 · Hub Salvage Ltd N9063QBalloon Works FIREFLY 8B · S/N F8B-331Cancelled Dec 11, 2006 · Triennial form not returned · Built 1991 · Jenkins Alan Lee N95690Taylorcraft BC12-D · S/N 7990Cancelled Aug 5, 2004 · Triennial form not returned · Built 1946 · Jackson Terry C N25RNSchempp-Hirth VENTUS B/16.6 · S/N 221Cancelled Nov 25, 2003 · Triennial form not returned · Built 1985 · Curry Shawn R N9225DPiper PA-22-160 · S/N 22-6285Cancelled May 20, 2002 · Triennial form not returned · Built 1958 · Lambert James D N32KWWells Kenneth N GLASAIR-SH2 · S/N 528Cancelled Nov 22, 1994 · Triennial form not returned · Wells Kenneth N N199AEiriavion PIK 20D · S/N 20537Cancelled Jul 11, 1984 · Administratively canceled · Corder Kevan N2989SCessna 150G · S/N 15066889Cancelled May 18, 1976 · Built 1967 · Scofield Malcolm Jr N1CWWilkinson Charles COUGAR 1 · S/N 1CMWCancelled Jul 18, 1975 · Built 1971 · Wilkinson Charles M N1273RBellanca 14-19-3A · S/N 4331Cancelled Nov 20, 1973 · William C Morgan N8435GCessna 150F · S/N 15062535Cancelled Jun 30, 1970 · Gurley Gordon B N3174BCessna 170B · S/N 25416Cancelled Jun 18, 1965 · Exported to Canada · Built 1953 · Speer George A

Back to Brighton, CO