Skip to content

Cancelled registrations · 610

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 = 'MO' AND d.registrant_city = 'ST LOUIS' 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 = 'MO' AND d.registrant_city = 'ST LOUIS'
  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 = 'MO' AND d.registrant_city = 'ST LOUIS'
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.

N65MCRockwell International NA-265-65 · S/N 465-36Cancelled Feb 1, 2025 · Built 1980 · N65mc LLC N3284PPiper PA-23-160 · S/N 23-1229Cancelled Sep 30, 2023 · Revoked, canceled · Built 1957 · Mack Oscar C N19780Aeronca K · S/N 265Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1937 · Stix Al III N265MPDassault/Sud FAN JET FALCON · S/N 265Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Built 1972 · Jnm Air Delaware LLC N337Timm COLLEGIATEM-150 · S/N 101Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1928 · Stix Albert I N70478Piper J3C-65 · S/N 17480Cancelled May 23, 2022 · Registration pending, canceled · Built 1946 N23454Cessna 150H · S/N 15068958Cancelled Apr 3, 2021 · Registration expired, pending cancellation · Built 1968 · Krause Anthony L N2357EPiper PA-38-112 · S/N 38-78A0447Cancelled Jul 24, 2020 · Wings Of Hope Inc N95712Taylorcraft BF · S/N 8012Cancelled Jul 10, 2020 · Revoked, canceled · Built 1946 · Swan Ray N64210Taylorcraft DC-65 · S/N 6149Cancelled Apr 3, 2020 · Revoked, canceled · Built 1942 · Gunn Leonard N6426MStinson 108 · S/N 1084426Cancelled Apr 3, 2020 · Revoked, canceled · Built 1948 · Fowler Raymond J N6906HPiper J3C-65 · S/N 20139Cancelled Mar 25, 2020 · Revoked, canceled · Built 1946 · Mullen Bill R N26689Taylorcraft BL-65 · S/N 2031Cancelled Mar 20, 2020 · Revoked, canceled · Built 1940 · Ennen Paul N3328RCessna 182L · S/N 18258628Cancelled Feb 12, 2020 · Exported to Paraguay · Built 1967 · Wings Of Hope Inc N36161Taylorcraft BC12-65 · S/N 3140Cancelled Dec 13, 2019 · Revoked, canceled · Built 1941 · Carnahan Kenneth Jr N4423EAeronca S7CCM · S/N 7DC-62Cancelled Sep 14, 2019 · Revoked, canceled · Built 1948 · Ill Mo Van And Storage Co N85957Aeronca 11AC · S/N 11AC377Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Ericson Don N8685EBensen B-8M · S/N LR1Cancelled Sep 6, 2019 · Revoked, canceled · Built 1960 · Lambert Ralph D N87794Piper J3C-65 · S/N 15452Cancelled Aug 5, 2019 · Revoked, pending cancellation · Built 1946 · Dalton Jimmie L N15461Porterfield 35-70 · S/N 161Cancelled May 6, 2019 · Revoked, canceled · Built 1935 · Weatherford John N74BJRockwell International NA-265-65 · S/N 465-44Cancelled Mar 29, 2019 · Second renewal notice · Built 1980 · Wings Of Hope N7950LBeech A23-19 · S/N MB-150Cancelled Dec 15, 2018 · Built 1966 · Wings Of Hope N285SKEmbraer EMB-145LR · S/N 145435Cancelled Aug 30, 2018 · Exported to Bahamas · Built 2001 · Avtran LLC N50117Taylorcraft A · S/N 5469Cancelled May 18, 2018 · Revoked, canceled · Built 1943 · Coile William N6996MStinson 108 · S/N 1084996Cancelled Apr 6, 2018 · Revoked, canceled · Built 1948 · Weast Everett N31570Stinson 10A · S/N 7819Cancelled Mar 23, 2018 · Revoked, canceled · Built 1941 · Warren George E N3662TBalloon Works FIREFLY 7 · S/N F7-054Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1983 · Thornton Floyd R N99400Engineering & Research ERCOUPE 415-C · S/N 2023Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Gray Fred W N52453Aeronca 65-TC · S/N 10211TCancelled Nov 20, 2017 · Revoked, canceled · Built 1941 · Payne Donald E N23089Luscombe 8A · S/N 1013Cancelled Oct 28, 2017 · Revoked, canceled · Built 1939 · Myers Jimmy D N10CTBell 206B · S/N 2113Cancelled Oct 19, 2017 · Registration expired, pending cancellation · Built 1976 · St Louis Public Schools N53652Cessna 337G · S/N 33701758Cancelled Sep 18, 2017 · Registration expired, pending cancellation · Built 1976 · St Louis Public Schools N66827Piper PA-31P · S/N 31P-7400186Cancelled Sep 18, 2017 · Registration expired, pending cancellation · Built 1973 · St Louis Public Schools N2355JBeech 23 · S/N M-313Cancelled Jun 2, 2017 · First renewal notice · Built 1963 · Wings Of Hope N725GYakovlev YAK-18A · S/N 1001Cancelled Jun 1, 2017 · Registration expired, pending cancellation · Built 1956 · Grushewsky Igor N2989YCameron Balloons US N-160 · S/N 5211Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1986 · Spectrum Sky Sports Ltd N6000NAero Commander 560-E · S/N 531Cancelled Feb 16, 2017 · Registration expired, pending cancellation · Built 1957 · Wings Of Hope N75YDConvair 240 · S/N 86Cancelled Feb 4, 2017 · Revoked, canceled · Built 1948 · Engine Air Ltd N777FCessna 170 · S/N 18591Cancelled Feb 4, 2017 · Revoked, canceled · Built 1948 · Hunt Leroy Jr N9017CS L Lambert BABY ACE D · S/N 3Cancelled Feb 4, 2017 · Revoked, canceled · Built 1956 · Lambert Stafford L N2555YCessna 172D · S/N 17249855Cancelled Sep 9, 2016 · Registration expired, pending cancellation · Built 1962 · Kosic John DBA N57303Piper PA-28-140 · S/N 28-7425086Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1973 · White Knuckle Flyers Inc N54154Bell-Regan 47D1 · S/N HRB-1Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1966 · Foster C Tom N9183XAerostar International BUNY · S/N BUNY-3001Cancelled May 7, 2015 · Registration expired, pending cancellation · Built 1994 · Mississippi River Balloon Transit Co N7096EGulfstream Aerospace G-1159A · S/N 498Cancelled May 6, 2015 · Registration expired, pending cancellation · United States Army N6555LDassault-Breguet FALCON 20 · S/N 085Cancelled Apr 30, 2015 · Wings Of Hope N87CMNorth American NA-265-40 · S/N 282-21Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1964 · Intermark Capitol Corp N843BHawker Siddeley DH.125-400A · S/N NA742Cancelled Mar 23, 2015 · Built 1970 · Wings Of Hope N86CPNorth American NA-265-60 · S/N 306-76Cancelled Mar 23, 2015 · Built 1974 · Wings Of Hope N5692UPiper PA-28-140 · S/N 28-26489Cancelled Dec 18, 2014 · Registration expired, pending cancellation · Built 1969 · Dutt Haynes Jennifer K

Back to St Louis, MO