Skip to content

Cancelled registrations · 80

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 = 'OK' AND d.registrant_city = 'EDMOND' 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 = 'OK' AND d.registrant_city = 'EDMOND'
  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 = 'OK' AND d.registrant_city = 'EDMOND'
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.

N18XFStephen E Massel HUMMEL H5 · S/N 245Cancelled Jan 31, 2026 · Sale reported, canceled · Built 2019 N443KJKyle Jones AVENTURA II · S/N AA2A00183Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Jones Kyle N7247BBeech J35 · S/N D-5578Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Harting Matthew H Trustee N2938TAero Commander 100-180 · S/N 068Cancelled Jan 14, 2023 · Sale reported, canceled · Built 1967 N7040GCessna 150L · S/N 15074611Cancelled Feb 16, 2021 · Sale reported, canceled N48PJCessna 550 · S/N 550-0668Cancelled Jan 28, 2021 · Exported to Mexico · Built 1991 · It & Associates Inc N5509UPiper PA-28-140 · S/N 28-26221Cancelled Jan 9, 2021 · Registration expired, pending cancellation · Built 1969 · Norris Timothy J N6076EBeech K35 · S/N D-6146Cancelled Jan 9, 2021 · Registration expired, pending cancellation · Built 1959 · Lake Gary M N28005Gulfstream American AA-5B · S/N AA5B0937Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Built 1978 · Stracke Robert J N8379EMooney M20A · S/N 1557Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Built 1960 · Guthrie Larry J N52ADPranevich Dennis SIDEWINDER · S/N 212875Cancelled May 1, 2020 · Registration expired, pending cancellation · Homic Michael J N300GDCessna 425 · S/N 425-0074Cancelled Feb 4, 2020 · Built 1980 · Downing Aviation LLC N113DMMiller Donald L SPEZIO SPORT · S/N 113Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Miller Donald L N8515RBellanca 14-19-3 · S/N 4277Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Built 1966 · Cobb James Paul Sr N325JKCirrus Design SR22T · S/N 1290Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 2016 · Abide Aviation LLC N754ATDJI PHANTOM 3 ADVANCED · S/N P76DCK17A20374Cancelled Jul 9, 2019 · Registration expired, pending cancellation · Air Today Productions LLC N452RJBeech D55 · S/N TE-535Cancelled May 21, 2019 · Built 1968 · Baron D LLC N353ATDJI INSPIRE 1 PRO · S/N W21ACI16010362Cancelled May 4, 2019 · Registration expired, pending cancellation · Air Today Productions LLC N77020Cessna 120 · S/N 11466Cancelled Feb 25, 2019 · Registration expired, pending cancellation · Built 1946 · Chapman Erin A N214WWDJI PHANTOM 3 PROFESSION · S/N P76DCE29013855Cancelled Feb 23, 2019 · Registration expired, pending cancellation · Wilson William A N2058JCarter David W T-BIRD · S/N TBDWCO11852Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Built 2002 · Dunn Quentin L N99333Engineering & Research ERCOUPE 415-C · S/N 1956Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1946 · Homic Michael J N8749KStinson 108-1 · S/N 108-1749Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 1947 · Archer Emory D N10794Piper PA-24-250 · S/N 1557Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1959 · Mouravieff Pierre N751CBBuchholz Chuck EAGLE II · S/N 2CBCancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 2005 · Apel Thomas G N2313WBeech A23A · S/N M-914Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1965 · Crane Sam R N11477Waco QDC · S/N 3506Cancelled May 18, 2015 · Registration expired, pending cancellation · Vintage Wings Inc N6570GCessna 150L · S/N 15072070Cancelled May 11, 2015 · Sale reported, canceled · Built 1970 N70201Martin Clay CHALLENGER II · S/N CH2-1101-2146Cancelled Nov 4, 2013 · Registration expired, pending cancellation · Built 2002 · Martin Clay E N300KSExtra Flugzeugbau EA-300 · S/N 041Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1993 · Afterburner Consultants Inc N7074UPiper J3C-65 · S/N 16790Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Built 1946 · Two States Aviation Inc N606JDDickinson James A MINI MAX R1600 · S/N KIT 606Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1993 · Sapp Charles M N190SACessna 190 · S/N 7525Cancelled Aug 27, 2013 · Sale reported, canceled · Built 1950 N8783SCessna 150F · S/N 15062083Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1965 N8764RPiper J4E · S/N 4-1512Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1941 N6281SCessna 150G · S/N 15067081Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1967 N8280LCessna 172H · S/N 17256480Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1967 · Carroll Donald W N398BGMills G A/Mills B G OUTBACK · S/N S9903-0189Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Mills Gregory A N65REChase Steve RALLY 3A · S/N 64776Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1982 · Skyking Aviation Inc N6543BMooney M20A · S/N 1212Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1958 · Diamond Helen Irine N326BCessna 525 · S/N 525-0302Cancelled Feb 5, 2013 · Exported to Canada · Built 1999 · Genesis Aircraft Group N6085WPiper PA-28-140 · S/N 28-20099Cancelled Oct 2, 2012 · Built 1964 · Smittle Darrell A N5391KRyan NAVION B · S/N NAV-4-2291-BCancelled Aug 21, 2012 · Revoked, canceled · Built 1951 · Mcclain N L N6235Gibson-Schwartz-Maxwell-Graf PIETENPOL P-MOD. · S/N US4Cancelled Mar 11, 2011 · Expired dealer · Built 1972 · Haynes William J DBA N6714EBeech C23 · S/N M-2200Cancelled Jan 7, 2011 · Built 1979 · Holloway Donald G N227EPatterson Leonard P RAF 2000 GTX SE · S/N H2-02-13-555Cancelled Jan 6, 2011 · Triennial form not returned · Patterson Leonard P N35019Piper J5A · S/N 5-531Cancelled Dec 22, 2010 · Revoked, pending cancellation · Built 1941 · Winningham Vance N425ERCessna 172R · S/N 17280646Cancelled Sep 23, 2010 · Exported to Thailand · Built 1998 · Orkin Aviation LLC N6917UMooney M20D · S/N 249Cancelled Sep 22, 2008 · Exported to Canada · Built 1964 · Mcdonough Casey N280RLearjet 24B · S/N 188Cancelled Jan 14, 2008 · Triennial form not returned · Built 1969 · Spirit Wing Aviation

Back to Edmond, OK