Skip to content

Cancelled registrations · 98

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 = 'VA' AND d.registrant_city = 'MANASSAS' 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 = 'VA' AND d.registrant_city = 'MANASSAS'
  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 = 'VA' AND d.registrant_city = 'MANASSAS'
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.

N99AUAurora Flight Sciences ODYSSEUS · S/N AU-099Cancelled Sep 10, 2026 · Aurora Flight Sciences Corp N98AUAurora Flight Sciences ODYSSEUS · S/N AU-098Cancelled Aug 22, 2026 · Aurora Flight Sciences Corporation N850MMSocata TBM 700 · S/N 449Cancelled Oct 17, 2023 · Exported to San Marino · Built 2008 · Emerald Aviation Inc N5509DBeech H35 · S/N D-5055Cancelled Jun 10, 2023 · Registration pending, canceled · Built 1957 N911PVAurora Flight Sciences P3 POC 1.0 · S/N AU-088Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Aurora Flight Sciences Corp N87AUAurora Flight Sciences PEGASUS · S/N AU-087Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Aurora Flight Sciences Corp N58AUDiamond Aircraft Ind DA42MNG · S/N 42.MN104Cancelled Jun 29, 2022 · Exported to Qatar · Built 2019 · Aurora Flight Sciences Corp N59AUDiamond Aircraft Ind DA42MNG · S/N 42.MN105Cancelled Jun 29, 2022 · Exported to Qatar · Built 2019 · Aurora Flight Sciences Corp N23NJCessna 172N · S/N 17273230Cancelled Mar 4, 2022 · Sale reported · Built 1979 N83AUAurora Flight Sciences PEGASUS · S/N AU-083Cancelled Jun 29, 2021 · Registration expired · Built 2018 · Aurora Flight Sciences Corp N6272YPiper PA-23-250 · S/N 27-3517Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 1967 · Deeba Inc N8304FPiper PA-28-181 · S/N 28-8390012Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Built 1982 · Dulles Aviation Inc N3631GSchweizer G-164B · S/N 763BCancelled Nov 29, 2019 · Registration expired, pending cancellation · Built 1984 · Dusters Airlease LLC Trustee N77992Luscombe 8A · S/N 3719Cancelled Jun 12, 2019 · Revoked, canceled · Built 1946 · Queen A Teal Jr N664PAAurora Flight Sciences SKATE · S/N SKATE0001Cancelled Nov 17, 2018 · First renewal notice · Aurora Flight Sciences Corp N82587Piper PA-28-161 · S/N 28-8116026Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Built 1980 · Dulles Aviation Inc N701PDDrzymala Peter S STOL CH 701 · S/N 74890Cancelled Jun 26, 2018 · Registration pending, canceled · Built 2007 N6056Hiller OH-23B · S/N 51-16203Cancelled May 3, 2018 · Registration expired, pending cancellation · Built 1951 · N6056 LLC N8576NHummel ULTRACRUISER · S/N ULCCancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 2005 · Stern Dustin S N824AUAurora Flight Sciences GOLDENEYE 50 · S/N AU-024Cancelled Mar 30, 2018 · Registration expired, pending cancellation · Built 2006 · Aurora Flight Sciences Corp N8101EMooney M20A · S/N 1372Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 1959 · Honan William M N93958Engineering & Research 415-C · S/N 1281Cancelled Mar 1, 2018 · Revoked, pending cancellation · Built 1946 · Kulp And Kulp Aviation N7578UCessna 150M · S/N 15077746Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1975 · Babber Sudesh N839AUAurora Flight Sciences GOLDENEYE 80 · S/N AU039Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Aurora Flight Sciences Corp N841AUAurora Flight Sciences GOLDENEYE 80 · S/N AU041Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Aurora Flight Sciences Corp N83700Bell 412EP · S/N 36208Cancelled Nov 29, 2017 · Exported to Canada · Built 1998 · Aircraft Associates Inc N83713Bell 412EP · S/N 36205Cancelled Nov 29, 2017 · Exported to Canada · Built 1998 · Aircraft Associates Inc N827AUAurora Flight Sciences GOLDENEYE 50 · S/N AU-027Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Built 2006 · Aurora Flight Sciences Corp N828AUAurora Flight Sciences GOLDENEYE 50 · S/N AU-028Cancelled Oct 26, 2017 · Registration expired, pending cancellation · Built 2006 · Aurora Flight Sciences Corp N58JTBeech 58P · S/N TJ-212Cancelled Mar 7, 2017 · Built 1979 · Vamp Enterprieses LLC N710APDJI MATRICE 100 · S/N M02DCJ09020011Cancelled Nov 8, 2016 · Progeny Systems Corp N414BKCessna 414A · S/N 414A-0022Cancelled Oct 4, 2016 · Exported to Venezuela · Built 1978 · Emerald Aviation Inc N782ACRobinson Helicopter R44 II · S/N 11577Cancelled May 27, 2015 · Exported to Canada · Built 2007 · Emerald Aviation Inc Trustee N562GXBombardier BD-700-1A10 · S/N 9562Cancelled Apr 14, 2015 · Exported to Isle Of Man · Emerald Aviation Inc Trustee N484SCPiper PA-31T · S/N 31T-7820022Cancelled Jan 22, 2015 · Exported to Venezuela · Built 1977 · Emerald Aviation Inc Trustee N4657KMaule M-7-235C · S/N 25053CCancelled Dec 10, 2014 · Exported to Ukraine · Built 2000 · Emerald Aviation Inc Trustee N892PBCessna 550 · S/N 550-0070Cancelled May 13, 2014 · Exported to Venezuela · Built 1979 · Emerald Aviation Inc N3074KCaughran Terry BEAVER RX 550 · S/N 10FFBCancelled Oct 31, 2013 · Registration expired, pending cancellation · Hiles Terry N8487EClark William E JR VARIEZE · S/N 292Cancelled Oct 28, 2013 · Registration expired, pending cancellation · Built 1982 · Steen Douglas S N257SGWillmore Ellis G LOW WING MONOPLANE · S/N 1Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1995 · Willmore Ellis G N9794WPiper PA-28-140 · S/N 28-23287Cancelled Sep 12, 2013 · Registration expired, pending cancellation · Built 1967 · Shaxam Inc N6981JArnold Jack E RANS S-12 AIRAILE · S/N 0590021Cancelled Aug 27, 2013 · Sale reported, canceled N87555Raytheon 1900D · S/N UE-234Cancelled Jun 19, 2013 · Exported to Niger · Built 1996 · Emerald Aviation Inc Trustee N90910Piper PA-18-150 · S/N 18-8109046Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Built 1981 · Martin C William Jr N6169VConsolidated Aeronautics LAKE LA-4-200 · S/N 822Cancelled Apr 26, 2013 · Registration expired, pending cancellation · Built 1977 · Latham William C N5291LPiper PA-28-180 · S/N 28-4592Cancelled Apr 8, 2013 · Registration expired, pending cancellation · Built 1968 · Baker Francis G N6876WPiper PA-28-140 · S/N 28-21032Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1965 N52AUDiamond Aircraft Ind DA42MNG · S/N 42.MN026Cancelled Dec 21, 2012 · Exported to Switzerland · Built 2012 · Aurora Flight Sciences N2927BI.C.A.-Brasov IS-28B2 · S/N 54Cancelled Sep 24, 2012 · Registration expired, pending cancellation · Built 1977 · Forrester Richard C III N61314Cessna 150J · S/N 15070957Cancelled Oct 20, 2011 · Built 1969 · Haase Douglas R

Back to Manassas, VA