Monroe, WI
Cancelled registrations · 67
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 = 'WI' AND d.registrant_city = 'MONROE' 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 = 'WI' AND d.registrant_city = 'MONROE' 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.
N119MLBritish Aerospace BAE 125 SERIES 800A · S/N NA0445N816BGBritish Aerospace BAE 125 SERIES 800A · S/N NA0440N238RABritish Aerospace BAE 125 SERIES 800A · S/N 258035N26SCBritish Aerospace HS 125-700A · S/N NA0283N805LXRaytheon HAWKER 800XP · S/N 258374N111ZSBritish Aerospace HS 125-700A · S/N 257076N35WPHawker Siddeley HS-125-600A · S/N 256029N172CMCessna 172RG · S/N 172RG0787N4689LCessna 152 · S/N 15284217N6593LCessna 152 · S/N 15284452N757SHCessna 152 · S/N 15279964N4633BCessna 152 · S/N 15283559N209TSBritish Aerospace HS 125-700A · S/N NA0209N68795Cessna 152 · S/N 15282378N3175TBalloon Works FIREFLY 7B-15 · S/N F7B-367N5177BCessna 152 · S/N 15283793N64920Cessna 152 · S/N 15285283N25339Cessna 152 · S/N 15280603N4450CCessna 152 · S/N 15285715N757KWCessna 152 · S/N 15279810N95904Cessna 152 · S/N 15285983N89534Cessna 152 · S/N 15282774N24789Cessna 172S · S/N 172S8805N739GACessna 172N · S/N 17270521N6755ECessna 172N · S/N 17272061N1727RCessna R182 · S/N R18200537N3884RCessna 172H · S/N 17255384N5303LCessna 152 · S/N 15284291N25796Cessna 152 · S/N 15280790N3916QCessna 172L · S/N 17260016N757BRCessna 152 · S/N 15279614N65642Cessna 172P · S/N 17275795N9584LCessna 172P · S/N 17276584N25371Cessna 152 · S/N 15280620N52209Cessna 172P · S/N 17274437N739MTCessna 172N · S/N 17270656N67918Cessna 152 · S/N 15282097N4921BCessna 152 · S/N 15283705N68352Cessna 152 · S/N 15282278N24359Cessna 152 · S/N 15280233N7275GCessna 172R · S/N 17280788N69107Cessna 152 · S/N 15282485N67593Cessna 152 · S/N 15281934N94197Cessna 152 · S/N 15285619N789MFCessna 152 · S/N 15280998N25762Cessna 152 · S/N 15280769N5175RCessna 172S · S/N 172S9048N46860Cessna 152 · S/N 15283122N68611Cessna 152 · S/N 15282319N69211Cessna 152 · S/N 15282559
Back to Monroe, WI