Skip to content

Cancelled registrations · 40

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 = 'CHANTILLY' 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 = 'CHANTILLY'
  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 = 'CHANTILLY'
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.

N4958PCessna 150L · S/N 15074981Cancelled Jan 21, 2026 · Exported to El Salvador · Built 1974 · N5967m LLC N2508LCessna 172H · S/N 17255708Cancelled Apr 30, 2024 · Exported to El Salvador · Built 1966 · N5967m LLC N622REPae ISR RESOLUTE EAGLE · S/N AFF001Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Pae Isr LLC N623REPae ISR RESOLUTE EAGLE · S/N AFF002Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Pae Isr LLC N709WSDJI PHANTOM 3 PROFESSION · S/N P76DCI07010169Cancelled Nov 4, 2019 · Registration expired, pending cancellation · 5 Star Aerial Solutions LLC N716MFDJI PHANTOM 3 PROFESSION · S/N P76DCF28016731Cancelled Nov 4, 2019 · Registration expired, pending cancellation · County Of Fairfax N716NJDJI PHANTOM 3 PROFESSION · S/N P76DCF26010918Cancelled Nov 4, 2019 · Registration expired, pending cancellation · County Of Fairfax N709XSDJI INSPIRE 1 · S/N W13DCK24052069Cancelled Oct 5, 2019 · Registration expired, pending cancellation · 5 Star Aerial Solutions LLC N672JD3D Robotics IRIS · S/N DPR-IRIS-001Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Dpr Construction N113BCSensefly EBEE · S/N EB-02-380Cancelled Mar 23, 2019 · Registration expired, pending cancellation · Bowman Consulting Group Ltd N801FTRockwell International NA-265-80 · S/N 380-16Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1975 · Flight Test Aerospace Inc N802FTRockwell International NA-265-80 · S/N 380-33Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1975 · Flight Test Aerospace Inc N4341MPiper PA-28-236 · S/N 28-8411010Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 1984 · Isles Aviation LLC N124HPPierce Henry E TU-HOLER · S/N 1124Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1990 · Burnam Maurice K N8689Fleet 2 · S/N 75Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1929 N339DCCorrick Gary S CHALLENGER II · S/N CH2-0104-CW-2418Cancelled Jan 25, 2012 · Corrick Gary S N11727Van Der Kaay KA-1 MOSQUITO · S/N 01Cancelled Jun 17, 2009 · Registration revoked · Built 1975 · Van Der Kaay Erik Karel N80JLLakeland Ultralights KOLB FIRESTAR I · S/N LAK3Cancelled Mar 12, 2009 · Triennial form not returned · Built 1994 · Kew Ralph E N8844HNorth American NAVION · S/N NAV-4-844Cancelled Jan 15, 2008 · Triennial form not returned · Built 1947 · Reid Garry S N23MVPiper PA-31T · S/N 31T-7720044Cancelled Nov 14, 2005 · Exported to Argentina · Built 1977 · Klune Logistics LLC N199NDPiper PA-31T · S/N 31T-7620035Cancelled Oct 19, 2005 · Exported to Argentina · Built 1976 · Klune Logistics LLC N57MRPiper PA-31T · S/N 31T-7620022Cancelled Sep 29, 2005 · Exported to Argentina · Built 1976 · Klune Logistics LLC N406MXBritish Aerospace BAE JETSTREAM 3101 · S/N 631Cancelled Aug 8, 2001 · Non-citizen corporation, flight hours not reported · Jet Acceptance Corporation N953LMBritish Aerospace BAE JETSTREAM 3201 · S/N 953Cancelled Jan 7, 1999 · Exported to Australia · Jet Acceptance Corporation N951AEBritish Aerospace BAE JETSTREAM 3201 · S/N 951Cancelled Jul 21, 1998 · Exported to Australia · Jet Acceptance Corporation N949AEBritish Aerospace BAE JETSTREAM 3201 · S/N 949Cancelled Jul 7, 1998 · Exported to Australia · Jet Acceptance Corporation N948AEBritish Aerospace BAE JETSTREAM 3201 · S/N 948Cancelled Jun 16, 1998 · Exported to Australia · Jet Acceptance Corporation N852JSBritish Aerospace BAE JETSTREAM 3101 · S/N 724Cancelled Jan 30, 1998 · Exported to Canada N778JXBritish Aerospace BAE JETSTREAM 3101 · S/N 778Cancelled Oct 31, 1997 · Exported to Canada · Jet Acceptance Corporation N223JLBritish Aerospace BAE JETSTREAM 3101 · S/N 764Cancelled Oct 1, 1997 · Exported to Canada · Jet Acceptance Corporation N767JXBritish Aerospace BAE JETSTREAM 3101 · S/N 767Cancelled Oct 1, 1997 · Exported to Canada · Jet Acceptance Corporation N636JXBritish Aerospace BAE JETSTREAM 3101 · S/N 636Cancelled Aug 15, 1997 · Exported to Sweden · Jet Acceptance Corporation N639JXBritish Aerospace BAE JETSTREAM 3101 · S/N 639Cancelled Jun 30, 1997 · Exported to Sweden · Jet Acceptance Corp N400MXBritish Aerospace BAE JETSTREAM 3101 · S/N 624Cancelled Oct 3, 1996 · Jet Acceptance Corp N401MXBritish Aerospace BAE JETSTREAM 3101 · S/N 628Cancelled Oct 3, 1996 · Jet Acceptance Corp N402MXBritish Aerospace BAE JETSTREAM 3101 · S/N 630Cancelled Oct 3, 1996 · Jet Acceptance Corp N403MXBritish Aerospace BAE JETSTREAM 3101 · S/N 632Cancelled Oct 3, 1996 · Jet Acceptance Corp N404MXBritish Aerospace BAE JETSTREAM 3101 · S/N 625Cancelled Oct 3, 1996 · Jet Acceptance Corp N235CAC A S A CN-235-100 · S/N C041Cancelled Aug 4, 1993 · Exported to Spain · Casa Aircraft USA Inc N9668NSaab-Fairchild 340A · S/N 340A-003Cancelled Sep 10, 1986 · Exported to Sweden · Fairchild Industries Inc

Back to Chantilly, VA