Skip to content

Cancelled registrations · 34

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 = 'O FALLON' 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 = 'O FALLON'
  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 = 'O FALLON'
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.

N230AEBell 206L-3 · S/N 51331Cancelled Nov 15, 2024 · Built 1990 · Air Evac Ems Inc N30427Piper J4A · S/N 4-1208Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 1940 · Wheeler Samuel C N346AEAerospatiale AS350 B2 ECUREUIL · S/N 2946Cancelled Jan 24, 2022 · Exported to Canada · Built 1996 · Air Evac Ems Inc N139AEBell Helicopter Textron 206L-1 · S/N 45546Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 1980 · Air Evac Ems Inc N335AEBell Helicopter Textron 206L-1 · S/N 45659Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Built 1981 · Air Evac Ems Inc N42833Piper J3C-65 · S/N 15151Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1945 · Madison William T III N600TWDassault-Breguet FALCON 10 · S/N 153Cancelled Feb 16, 2021 · Sale reported, canceled · Built 1979 N9348BCessna 175 · S/N 55148Cancelled May 29, 2020 · Registration expired, pending cancellation · Built 1958 · Bohnert Lee Franklin N8167UCessna 172F · S/N 17252067Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Built 1964 · Cronin Joseph M N721AGDJI PHANTOM 2 VISION + · S/N PH645249309 V2.0Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Gladov Greg V N2974ZMaggart Charles H ZENITH ZODIAC 601 XL · S/N 6-5778Cancelled Jul 9, 2019 · Bell Samuel J N105AEBell Helicopter Textron 206L-1 · S/N 45297Cancelled Apr 26, 2019 · Exported to Australia · Air Evac Ems Inc N121AEBell Helicopter Textron 206L-1 · S/N 45690Cancelled Oct 1, 2018 · Exported to Canada · Built 1981 · Air Evac Ems Inc N51AEBell Helicopter Textron 206L-1 · S/N 45165Cancelled Oct 1, 2018 · Exported to Canada · Built 1978 · Air Evac Ems Inc N74AEBell Helicopter Textron 206L-1 · S/N 45765Cancelled Oct 1, 2018 · Exported to Canada · Built 1983 · Air Evac Ems Inc N216SBell Helicopter Textron 206L-1 · S/N 45669Cancelled Jul 5, 2018 · Exported to Australia · Air Evac Ems Inc N61AEBell Helicopter Textron 206L-1 · S/N 45470Cancelled Jul 5, 2018 · Exported to Australia · Built 1980 · Air Evac Ems Inc N2966XPiper PA-32-300 · S/N 32-7940233Cancelled Mar 9, 2018 · Registration expired, pending cancellation · Built 1979 · Limb-A-Nator LLC N60905Cessna 150J · S/N 15070658Cancelled Mar 1, 2018 · Exported to Mexico · Built 1969 · Keeven Thomas R N19AEBell Helicopter Textron 206L-1 · S/N 45691Cancelled Jun 28, 2017 · Built 1981 · Air Evac Ems Inc N116AEBell Helicopter Textron 206L-1 · S/N 45632Cancelled May 26, 2017 · Built 1981 · Air Evac Ems Inc N117AEBell Helicopter Textron 206L-1 · S/N 45627Cancelled May 26, 2017 · Built 1981 · Air Evac Ems Inc N122AEBell Helicopter Textron 206L-1 · S/N 45276Cancelled May 26, 2017 · Built 1979 · Air Evac Ems Inc N127AEBell 206L-3 · S/N 51592Cancelled May 26, 2017 · Built 1992 · Air Evac Ems Inc N129AEBell Helicopter Textron 206L-1 · S/N 45547Cancelled May 26, 2017 · Built 1980 · Air Evac Ems Inc N287AEBell 206L-3 · S/N 51404Cancelled May 26, 2017 · Built 1990 · Air Evac Ems Inc N162NHEaston Gil ROTORWAY EXEC 162F · S/N 6370Cancelled Feb 7, 2017 · Built 2001 · Hisserich Nicholas S N65033Aerostar International RX-7 · S/N RX7-3126Cancelled May 20, 2015 · Registration expired, pending cancellation · Going Up Inc N114AEBell Helicopter Textron 206L-1 · S/N 45507Cancelled May 6, 2015 · First renewal notice · Built 1980 · Air Evac Ems Inc N5204Taylor BD-4 · S/N T-4987Cancelled Dec 18, 2014 · Sale reported, canceled · Built 1977 N88AEBell Helicopter Textron 206L-1 · S/N 45263Cancelled Feb 26, 2014 · Built 1979 · Air Evac Ems Inc N61113Cameron Balloons US N-90 · S/N 5532Cancelled May 19, 2009 · Triennial form not returned · Built 1989 · Gaines Jason K N6149XCameron Balloons US N-90 · S/N 5991Cancelled Apr 23, 2009 · Gaines Jason N7530GCessna 150L · S/N 15074688Cancelled Sep 12, 2006 · Exported to Philippines · Built 1973 · Kulp Carl R Jr

Back to O Fallon, MO