Skip to content

Cancelled registrations · 35

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 = 'MI' AND d.registrant_city = 'CHARLOTTE' 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 = 'MI' AND d.registrant_city = 'CHARLOTTE'
  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 = 'MI' AND d.registrant_city = 'CHARLOTTE'
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.

N46202Cessna 172I · S/N 17257104Cancelled Oct 21, 2023 · Sale reported, canceled · Built 1968 N2146PPiper PA-23 · S/N 23-748Cancelled Jul 23, 2020 · Built 1956 · Don S Falik LLC N2112SCole Douglas R AIR COMMAND ELITE · S/N AC582ECancelled Feb 21, 2020 · Sale reported, canceled N421EDCessna 421B · S/N 421B0044Cancelled Nov 27, 2019 · Registration expired, pending cancellation · Built 1970 · Tt Met LLC N250MFOMF OMF-100-160 · S/N 0025Cancelled Nov 25, 2019 · Registration expired, pending cancellation · Built 2002 · Tt-Met LLC N55020Piper PA-28-180 · S/N 28-7305293Cancelled May 30, 2018 · Sale reported, canceled · Built 1973 N43939CGS HAWK ARROW · S/N H-864-SSA-447-TRICancelled Mar 2, 2018 · Registration expired, pending cancellation · Troll John T N6122ZAlliant DESTINY FUSION · S/N F4A0037Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 2007 · Densmore Michael C N4197TRaven S55A · S/N S55A-942Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 1982 · Droscha Jeremy J N6118UDestiny Powered Parachutes NEON GREEN 2000 · S/N 1B0128Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 2007 · Morrissey John R N11700Ercoupe 415-C · S/N 3793Cancelled Dec 15, 2016 · Third renewal notice · Built 1946 · Wend Roger W N2281PPiper PA-23 · S/N 23-892Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Built 1957 · Don S Falik LLC N3237RCessna 411 · S/N 411-0237Cancelled Jun 27, 2013 · Sale reported, canceled · Built 1966 N8800CPiper PA-22 · S/N 22-1412Cancelled Jun 27, 2013 · Registration expired, pending cancellation · Built 1953 · Combs Jerry A N2798URaven Industries RALLY RX7 · S/N RX7-426Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Droscha Jeremy J N2562WMooney M20E · S/N 926Cancelled Jun 7, 2013 · Sale reported, canceled · Built 1965 N1291QCessna 150L · S/N 15072591Cancelled May 9, 2013 · Sale reported, canceled · Built 1971 N914AAMichigan Aerolight EAGLE 2 PLACE · S/N 400105Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1983 · Michigan Aerolights Inc N39BFS.O.C.A.T.A. MS894A · S/N 11.871Cancelled Sep 28, 2012 · Registration pending, canceled · Built 1972 N47068Hanes SKYBOLT-HS-1 · S/N EH-101Cancelled Sep 18, 2012 · Revoked, canceled · Hanes Earl L N85825Aeronca 11AC · S/N 11AC-234Cancelled Sep 6, 2012 · Registration pending, canceled · Built 1946 N22144Cessna 150H · S/N 15068092Cancelled Aug 10, 2012 · Sale reported, canceled · Built 1967 N22189Cessna 150H · S/N 15068126Cancelled Aug 10, 2012 · Sale reported, canceled · Built 1967 N1198RRaven S55A · S/N S55A-331Cancelled Jun 4, 2012 · Sale reported, canceled · Built 1977 N8626RSchweizer SGS 1-26 · S/N 159Cancelled Jun 2, 2009 · Exported to Indonesia · Built 1962 · Larder Lee R N36469Piper PA-28-181 · S/N 28-7890517Cancelled Apr 8, 2008 · Exported to Greece · Built 1978 · Hakes Mike N5404XCessna TU206G · S/N U20605720Cancelled Nov 12, 2004 · Exported to Canada · Built 1980 · Crippen Donald D N50003Cessna 150H · S/N 15069000Cancelled Aug 10, 2004 · Triennial form undeliverable · Built 1968 · Hamilton Ronald C N5200KCessna 172N · S/N 17274008Cancelled Oct 17, 2000 · Don S Falik LLC N67085Hiller UH-12B · S/N 656Cancelled Mar 26, 1982 · Howe Menzo C N4678TBenson GYROCOPTER B-8M · S/N 62 1 462 LCancelled Sep 28, 1973 · Bracy Rolland N8056PPiper PA-24 · S/N 24-3302Cancelled Jun 15, 1970 · Kleinfelt Ilene R N18835Aeronca K · S/N K101Cancelled Jun 6, 1965 · Briggs Ben N2165MPiper J3C-65 · S/N 20953Cancelled Oct 5, 1955 · Cooper & Bosworth Air Service N14148Bosworth Cecil BOSWORTH-LONGSTER HL · S/N 301Cancellation date not recorded · Built 1934 · Briggs Benjamin

Back to Charlotte, MI