Skip to content

Cancelled registrations · 613

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

N527KMCessna 182T · S/N 18282260Cancelled Jan 23, 2025 · Exported to Canada · Built 2010 · Triple Group LLC N682RWMcdonnell Douglas DC-9-81(MD-81) · S/N 48006Cancelled Nov 15, 2024 · Built 1981 · Olympia Aviation LLC N301CStinson 108-2 · S/N 108-3301Cancelled Jul 29, 2023 · Revoked, canceled · Built 1947 · Obrien Earl D N46536Cessna 152 · S/N 15283067Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1978 · Fix Daniel R N2731CBensen MOLLARD B8C · S/N M1Cancelled Jun 19, 2020 · Revoked, canceled · Built 1958 · Mollard Lawrence N2244KLuscombe 8A · S/N 4971Cancelled Apr 3, 2020 · Revoked, canceled · Built 1947 · Banck Mark G N6675PPiper PA-24-250 · S/N 24-1799Cancelled Feb 21, 2020 · Revoked, canceled · Built 1960 · Burgess C Welding Co N6922MStinson 108 · S/N 1084922Cancelled Feb 21, 2020 · Revoked, canceled · Built 1948 · Butler Harry O N9746HConsolidated Vultee SNV-1 · S/N 6016Cancelled Feb 21, 2020 · Revoked, canceled · Schuster Robert J N5816CBeech C35 · S/N D-2768Cancelled Feb 10, 2020 · Revoked, canceled · Built 1957 · Rickman Richard E N70038Aeronca L-3B · S/N 058B-9723Cancelled Dec 18, 2019 · Revoked, pending cancellation · Meier Charlie H N31935Aeronca 65-CA · S/N C12251Cancelled Nov 29, 2019 · Revoked, canceled · Built 1941 · Marzolf Lawrence E N46517Aeronca 0-58B · S/N 058B-1152Cancelled Nov 19, 2019 · Revoked, pending cancellation · Built 1942 · Christ Arthur R N69778Fairchild M-62A · S/N 255Cancelled Oct 21, 2019 · Revoked, canceled · Bailey Harry E N453LMDJI INSPIRE 1 · S/N W13DCF19040590Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Detroit Aircraft N87383Ercoupe 415-C · S/N 556Cancelled Aug 5, 2019 · Revoked, canceled · Built 1946 · Cox Curtis C N1036DCessna 190 · S/N 7648Cancelled Jul 3, 2019 · Revoked, canceled · Built 1951 · Menger James E N32365Porterfield CP-55 · S/N 819Cancelled Apr 22, 2019 · Revoked, canceled · Built 1940 · Pattison Duane M N450LMLockheed Martin Procerus Tech INDAGO · S/N 3545Cancelled Apr 17, 2019 · Registration expired, pending cancellation · Detroit Aircraft N98447Piper J3C-65 · S/N 18641Cancelled Jan 16, 2019 · Revoked, canceled · Built 1946 · Erikson Lester A N2684HEngineering & Research ERCOUPE 415-C · S/N 3309Cancelled Aug 2, 2018 · Revoked, canceled · Built 1946 · Jones James H N9739KStinson 108-2 · S/N 1082739Cancelled Jul 26, 2018 · Revoked, canceled · Built 1947 · Wampler Harry B N84871Aeronca 7AC · S/N 7AC-3590Cancelled Jul 19, 2018 · Revoked, canceled · Built 1946 · Stephen William N3310EAeronca 7AC · S/N 7AC6754Cancelled May 18, 2018 · Revoked, canceled · Built 1947 · Black Joseph R N9229LAmerican AA-1A · S/N AA1A-0129Cancelled Mar 23, 2018 · Revoked, canceled · Built 1971 · University Of Detroit Flg Club Inc N4119HCameron Balloons N-77 · S/N 6121Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 1997 · Pontiac-Gmc Division N26000Rearwin 8135 · S/N 872Cancelled Nov 22, 2017 · Revoked, canceled · Built 1941 · Rasmussen Viktor N76507Cessna 140 · S/N 10939Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Lipski George N9047ZNorth American SNJ-5 · S/N 492991Cancelled Nov 21, 2017 · Revoked, canceled · Built 1949 · Aerial Advertisers Inc N93490Engineering & Research ERCOUPE 415-C · S/N 812Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Wagner Carl J N54415Fairchild M-62A · S/N T423141Cancelled Nov 20, 2017 · Revoked, canceled · Built 1942 · Pinsky Gerald Bernard N2348NCessna 120 · S/N 12594Cancelled Oct 28, 2017 · Revoked, canceled · Built 1947 · Rambus Bernard N84274Aeronca 7AC · S/N 7AC2966Cancelled Oct 28, 2017 · Revoked, pending cancellation · Built 1946 · Cujar George H N559LGrumman American Avn. G-1159 · S/N 152Cancelled May 23, 2017 · Registration expired, pending cancellation · Little Caesar Enterprises Inc N43829Piper PA-32R-300 · S/N 32R-7780527Cancelled Mar 15, 2017 · Registration expired · Built 1977 · Tuskegee Airmen National Historical Museum N75BGCessna 172M · S/N 17265064Cancelled Mar 6, 2017 · Registration expired, pending cancellation · Built 1975 · Leyshock Air Management Co N93WCGypsy Trikes FALCON-2 · S/N 2008-01Cancelled Feb 17, 2017 · Registration expired, pending cancellation · Czygan William IV N76854Cessna 140 · S/N 11288Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Boltach Joseph P Jr N80314Beech D18S · S/N AA-26Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Aviation Leasing Inc N8766NPiper PA-28-140 · S/N 28-25588Cancelled Feb 4, 2017 · Revoked, canceled · Built 1969 · Rea Timothy N65WCQuicksilver MXIIA · S/N 1985-01Cancelled May 20, 2015 · Registration expired, pending cancellation · Czygan William IV N5985YPiper PA-23-250 · S/N 27-3158Cancelled May 11, 2015 · Registration expired, pending cancellation · Built 1966 · Shaw Willie L N300ZCessna 310 · S/N 35017Cancelled Dec 22, 2014 · Revoked, canceled · Built 1955 · Shacket Ben N8472UCessna 172F · S/N 17252372Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1964 · Sentas Aero Inc N87176Cessna 402B · S/N 402B1011Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Built 1975 · Livingstone Seabourn S DBA N5277QCessna 150L · S/N 15073177Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1972 · Partyka Edward J N1985CCessna 170B · S/N 26130Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1953 · Burnley Tom N7511CCameron Balloons US N-90 · S/N 5740Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1991 · Cadillac Motor Car Division N9998BCessna 182A · S/N 34398Cancelled Oct 28, 2013 · Registration expired, pending cancellation · Built 1957 · Michigan Bank Na N7132SCessna 150H · S/N 15067832Cancelled Oct 24, 2013 · Registration expired, pending cancellation · Built 1967 · Purkiss Todd M

Back to Detroit, MI