Skip to content

Cancelled registrations · 38

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

N14UDDonald W Eagan KOLB MARK III CLASIC · S/N M3-157Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Eagan Donald W N81267Fairchild 24R-46 · S/N R46167Cancelled Sep 13, 2019 · Revoked, pending cancellation · Built 1946 · Johnson Richard L N22644Taylorcraft BL-65 · S/N 1291Cancelled Jul 26, 2018 · Revoked, canceled · Built 1939 · Reiff Edward C N806LJLearjet 23 · S/N 23-073Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1965 · A-Liner 8 Avn N651TACessna 152 · S/N 15280516Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Taras Industries Ltd N2109DBeech D35 · S/N D-3454Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Built 1953 · Quality Computer Systems Inc N45AARaven S55A · S/N S55A-588Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1979 · Peak Corporation N8265KFairchild 22 C7AM · S/N 1037Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Cleavinger David C N6428Woodcock B-8 GYROCOPTER · S/N 5580Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 1971 · Woodcock Harold V N270JRRadziewics John DRIFTER XP 503 · S/N DR0270Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Built 1986 · Mccoy Richard B N79LWLibke-Wiklund BJ-1B DUSTER · S/N BJ-1B-97Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1980 · Libke Donald A N86144Aeronca 11AC · S/N 11AC-574Cancelled Mar 7, 2013 · Sale reported, canceled · Built 1946 N30BDMarzewski BD-5B · S/N 3Cancelled Sep 25, 2012 · Registration expired, pending cancellation · Built 1975 · Marzewski Leonard N39219Wesley Michael B-10 · S/N PO 1081Cancelled Aug 8, 2012 · Sale reported, canceled · Built 1983 N1531DBalloon Works FIREFLY 7 · S/N 10167Cancelled Aug 7, 2012 · Registration expired, pending cancellation · Built 1980 · Balloon Experience Inc N355CBeech H-18 · S/N BA-700Cancelled Jul 18, 2011 · Triennial form not returned · Built 1964 · Roush Air Inc N104RJJud B-8M · S/N 363464059Cancelled Sep 21, 2009 · Registration revoked · Built 1973 · Boyer Russell K N100BPRockwell International NA-265-80 · S/N 380-48Cancelled Oct 4, 2006 · Exported to Mexico · Built 1976 · Psi Aviation Inc N7195RPiper PA-28-140 · S/N 28-21909Cancelled Nov 22, 2004 · Triennial form not returned · Built 1966 · Oakland Southwest Airport Inc N6360CPiper PA-28-161 · S/N 28-7816414Cancelled Feb 17, 1999 · Triennial form not returned · Glos Flying Service Inc N688JDDemers Joseph N FP 202 · S/N 2289Cancelled Oct 15, 1998 · Triennial form not returned · Demers Joseph N N207RXDocs Prescription A · S/N 007Cancelled Jul 11, 1995 · Triennial form not returned · Kovach Alexander J N8226XPiper PA-28-161 · S/N 288016345Cancelled Dec 2, 1993 · Exported to Netherlands · Ilasenko Jeff N73814Cessna 207A · S/N 20700631Cancelled Nov 17, 1983 · A-Liner-8-Aviation Inc N10156Parr Special 1 · S/N 1Cancelled Apr 15, 1982 · Administratively canceled · Collins R N2158DPiper PA-32RT-300T · S/N 32R-7987053Cancelled May 22, 1981 · Built 1979 · Action Distributing Co Inc N7615RBeech B23 · S/N M-1238Cancelled Sep 10, 1979 · Exported to Canada · Connors Patrick F N3895Benson B-8 · S/N H-21023Cancelled Sep 8, 1976 · D Mac Hadley N8435UCessna 172F · S/N 17252335Cancelled Feb 23, 1976 · Rogers Arthur L N8393GCessna 150F · S/N 15062493Cancelled Mar 23, 1972 · Exported to Canada · Cohan William D N23766Stinson HW75 · S/N 7251Cancelled Sep 14, 1971 · Sold N48900Fairchild M-62 · S/N T43-7072Cancelled May 20, 1965 · Spanich Bonding And Welding Corp N4814KRyan NAVION · S/N NAV-4-1814Cancelled May 8, 1963 · Truax Leland D N6809KPiper PA-16 · S/N 16-638Cancelled Mar 5, 1962 · Exported to Canada · Kelsall D G N9358EAeronca 11AC · S/N 11AC-998Cancelled May 16, 1961 · Exported to Canada · Built 1946 · Fleury Edmund F N3973MPiper PA-12 · S/N 12-2857Cancelled Apr 25, 1960 · Exported to Germany · Built 1947 · Crackel S R Or Violet J N31676Waco VKS-7 · S/N 6117Cancelled Jan 14, 1960 · Exported to Canada · Built 1942 · Scott Robert E Sheedy James G Parkinson James R N1454NPiper J3C-65 · S/N 22983Cancelled Aug 20, 1958 · Exported to Canada · Built 1947 · Schmeisser George F

Back to Livonia, MI