Skip to content

Cancelled registrations · 201

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 = 'AL' AND d.registrant_city = 'MONTGOMERY' 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 = 'AL' AND d.registrant_city = 'MONTGOMERY'
  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 = 'AL' AND d.registrant_city = 'MONTGOMERY'
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.

N811AMBritish Aerospace BAE 125 SERIES 800A · S/N NA0444Cancelled Jan 7, 2026 · Mtw Aerospace Inc N750FCBeech 100 · S/N B-58Cancelled Sep 18, 2024 · Mtw Aerospace Inc N376MWRaytheon B300 · S/N FL376Cancelled Jun 10, 2024 · Mtw Aerospace Inc N52JADassault-Breguet FALCON 10 · S/N 59Cancelled Feb 13, 2023 · Sale reported, canceled · Built 1975 N140DSSerrato Dan STEWART MSTANG S-51D · S/N 161Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Stewart 51 Partner LLC N46CFCessna 560XL · S/N 560-5218Cancelled Oct 7, 2022 · Sale reported · Built 2001 N105AXBeech 400A · S/N RK-105Cancelled Jul 29, 2022 · Sale reported N5082NDugan Philip TITAN TORNADO · S/N S05J22SOHK0498Cancelled Jul 2, 2022 · Registration expired, pending cancellation · Built 2006 · Orendorf Wyatt E N98598Cessna 172P · S/N 17276320Cancelled Apr 14, 2022 · Sale reported, canceled · Built 1985 N525LTCessna 421B · S/N 421B0538Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Built 1973 · Macedonia Miracle Kingdom And Worship Center N208DJDJI INSPIRE 1 · S/N W13DCA22020738Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Alabama Forestry Commission N335YSchleicher K 8 B · S/N 8098Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Locke James M N9718JPiper PA-28-180 · S/N 28-3910Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 1967 · Sorrells Reginald L N2969UPiper PA-28-181 · S/N 28-8090014Cancelled Jun 5, 2021 · Sale reported, canceled · Built 1979 N3807BBeech F35 · S/N D-4068Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Built 1955 · Lofton Sidney S N25DLBeech C90 · S/N LJ-716Cancelled Apr 20, 2021 · Sale reported · Built 1977 N21NVLearjet 60 · S/N 268Cancelled Feb 1, 2021 · Mtw Aerospace Inc N7734TLearjet 60 · S/N 139Cancelled Feb 1, 2021 · Built 1998 · Mtw Aerospace Inc N80075Cessna 172M · S/N 17266352Cancelled Nov 20, 2020 · Sale reported, canceled N457MDCessna 525A · S/N 525A0009Cancelled Oct 17, 2020 · Sale reported · Built 2000 N72MMBeech 200 · S/N BB-497Cancelled Sep 16, 2020 · Sale reported · Built 1979 N988HWDJI PHANTOM 4 PRO OBSIDI · S/N 1892FCC0020011Cancelled Jul 21, 2020 · Alabama Department Of Transportation N711VLGrumman G-1159 · S/N 120Cancelled May 29, 2020 · Registration expired, pending cancellation · Built 1972 · Macon Co Greyhound Park Inc N42HNGates Learjet 35A · S/N 507Cancelled May 7, 2020 · Sale reported · Built 1983 N991HWDJI MAVIC PRO · S/N 163DG1N00DG3SCancelled Mar 16, 2020 · Alabama Department Of Transportation N172FSCessna 172N · S/N 17273632Cancelled Mar 6, 2020 · Sale reported, canceled · Built 1979 N203Canadair CL-600-2B16 · S/N 5374Cancelled Nov 20, 2019 · Sale reported · Built 1998 N24GJBeech C90 · S/N LJ-769Cancelled Jan 22, 2019 · Built 1978 · Mtw Aerospace Inc N539BALearjet 31 · S/N 033DCancelled Dec 15, 2018 · Built 1995 · Mtw Aerospace Inc N9528ACameron Balloons US V-77 · S/N 5649Cancelled Jul 9, 2018 · Built 1990 · Civil Air Patrol N340DPCessna 340A · S/N 340A0694Cancelled May 9, 2018 · Sale reported N333PPiper PA-31T · S/N 31T-8020002Cancelled Apr 3, 2018 · Built 1979 · Mtw Aerospace Inc N437CGBeech 95-A55 · S/N TC-468Cancelled Mar 27, 2018 · Registration expired, pending cancellation · Built 1963 · Summerlin C Larry N3559BBeech B50 · S/N CH-17Cancelled Mar 16, 2018 · Revoked, canceled · Built 1954 · Southern Bank Na N15JACessna 550 · S/N 550-0035Cancelled Mar 12, 2018 · Sale reported, pending cancellation · Built 1978 N127NSLearjet 31A · S/N 168Cancelled Mar 5, 2018 · Sale reported N1547Beech A200 · S/N BC-50Cancelled Feb 15, 2018 · Sale reported, canceled N1554Beech A200 · S/N BC-21Cancelled Feb 15, 2018 · Sale reported, canceled N2480WSchweizer SGS 2-33 · S/N 34Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 1967 · Civil Air Patrol Inc N6571SBeech E-90 · S/N LW-171Cancelled Feb 5, 2018 · Sale reported, pending cancellation · Built 1976 N72476Beech A200 · S/N BC-26Cancelled Feb 5, 2018 · Sale reported, pending cancellation N5751GCessna 150K · S/N 15071251Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1969 · Campbell Danny R N1900LBeech 1900D · S/N UE-185Cancelled Dec 7, 2017 · Built 1995 · Mtw Aerospace Inc N3KFBeech C90 · S/N LJ-530Cancelled Jun 27, 2017 · Registration expired, pending cancellation · Built 1971 · Mtw Aerospace Inc N8783Learjet 60 · S/N 006Cancelled Jun 27, 2017 · Built 1993 · Mtw Aerospace Inc N900LHDornier Luftfahrt DO 328-100 · S/N 3014Cancelled Jun 27, 2017 · Built 1994 · Mtw Aerospace Inc N7074GBeech A200 · S/N BC-17Cancelled Jan 31, 2017 · Sale reported N72472Beech A200 · S/N BC-11Cancelled Jan 31, 2017 · Sale reported N801BBCessna 550 · S/N 550-0801Cancelled Dec 28, 2016 · Built 1997 · Mtw Aerospace Inc N1900KBeech 1900D · S/N UE-152Cancelled Nov 2, 2016 · Built 1995 · Mtw Aerospace Inc

Back to Montgomery, AL