Waterloo, IA
Cancelled registrations · 280
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 = 'IA' AND d.registrant_city = 'WATERLOO' 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 = 'IA' AND d.registrant_city = 'WATERLOO' 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.
N51550Cessna T182T · S/N T18208934N50983Cessna 182T · S/N 18282148N5087GCessna 182T · S/N 18282151N5104HCessna 182T · S/N 18282158N5103LCessna 182T · S/N 18282157N5189NCessna 182T · S/N 18282161N5236FCessna 182T · S/N 18282165N2172VCessna 172S · S/N 172S10472N106KLCessna LC41-550FG · S/N 411108N5233NCessna T206H · S/N T20608856N51879Cessna 182T · S/N 18282160N5220NCessna 172S · S/N 172S10851N5063ACessna T182T · S/N T18208918N6185ZCessna 172R · S/N 17281524N215TMCessna 210R · S/N 21064970N6184UCessna 172R · S/N 17281517N6348UCessna 182T · S/N 18282143N896JACessna T206H · S/N T20608896N6204MCessna T182T · S/N T18208904N6336DCessna 182T · S/N 18282134N62036Cessna 172S · S/N 172S10803N10698Cessna T182T · S/N T18208801N62485Cessna T182T · S/N T18208850N6328HCessna 182T · S/N 18282133N6200HCessna T206H · S/N T20608878N6196HCessna 172S · S/N 172S10773N6200GCessna 172S · S/N 172S10795N844SPCessna 172S · S/N 172S8751N6203DCessna 182T · S/N 18282130N6295TCessna 182T · S/N 18282111N62849Cessna 182T · S/N 18282107N6306HCessna T182T · S/N T18208877N62913Cessna T182T · S/N T18208871N6256ACessna 172R · S/N 17281522N1288PCessna 182T · S/N 18282044N6236RCessna 172S · S/N 172S10699N6315RCessna 172S · S/N 172S10744N16887Cessna 172S · S/N 172S10614N1238GCessna 172R · S/N 17281450N10412Mooney M20R · S/N 29-0322N10876Cessna 172S · S/N 172S10603N1194PCessna 172S · S/N 172S10617N1553SCessna T182T · S/N T18208783N24119Cessna T206H · S/N T20608740N2412KCessna T206H · S/N T20608747N2358PCessna 182T · S/N 18281950N22807Cessna T182T · S/N T18208735N1208MCessna 172S · S/N 172S10413N499SRCirrus Design SR22 · S/N 2486N2183WCessna 182T · S/N 18281932
Back to Waterloo, IA