Kalamazoo, MI
Cancelled registrations · 134
Query with SQL
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 = 'KALAMAZOO' 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 = 'KALAMAZOO' 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.
N1925LBeech B19 · S/N MB-795N4090YBoven Larry D MINI 500 · S/N 0378N6256ACessna 182 · S/N 33056N1183MLutke Michael T ROTOWAY EXEC 90 · S/N J123151N7323LEagle Balloons C-7 · S/N E85785N52830Cessna 182P · S/N 18262880N35549Cessna 172I · S/N 17256827N27283Fairchild SA227-AC · S/N AC729N8436APiper PA-28-161 · S/N 288116317N12QQFroelich Del QUICKIE-I · S/N 296N2345JBeech 23 · S/N M-300N4053PRaven S55A · S/N S55A-858N2287MPiper PA-28-161 · S/N 28-7816272N377WBCessna T310Q · S/N 310Q0954N4446Dehavilland TIGER MOTH DH 82A · S/N 29552N5494BCessna 182 · S/N 33494N27837Piper PA-31-325 · S/N 31-7912011N704NECessna 150M · S/N 150 78736N2369APiper PA-38-112 · S/N 3878A0658N6648MCessna 182P · S/N 18263789N2244SAero Commander 560-F · S/N 560F-1043-15N1992MCessna 182P · S/N 18264521N6726HCessna 172M · S/N 17265557N97483Beech UC-45J · S/N 29629N98119Beech RC-45J · S/N 39217N73541Hiller H-23D · S/N 57-3036N93215Martin RB57A · S/N 52-1485N7286NCessna 182P · S/N 182-63073N5218WPiper PA-28-150 · S/N 28255N69776Cessna 310Q · S/N 310Q0971N55479Consolidated Vultee BT-13A · S/N 6424N2427QCessna 182K · S/N 18257627N2049ZCessna 150C · S/N 15059849N7824ZCessna 150C · S/N 15059924N4975FCessna U206B · S/N U206-0675N2230EAeronca 7AC · S/N 7AC-5804N5006Republic F-84F · S/N 51-9501N5046Republic F-84F · S/N 52-6486N7071XCessna 150A · S/N 15059171N1040ZLockheed T-33A · S/N 53-5219N41908Luscombe 8C · S/N 1869N27680Taylorcraft BL-65 · S/N 2322N30057Sikorsky UH-19C · S/N 14306N99245Engineering & Research ERCOUPE 415-C · S/N 1868N3351Grumman F8F-1 · S/N 90454N2813ACessna 180 · S/N 30013N4406EAeronca 11CC · S/N 11CC-229N96654Taylorcraft BC12-D · S/N 8954N6027MStinson 108-3 · S/N 108-4027N76276Cessna 140 · S/N 10684
Back to Kalamazoo, MI