Cape Girardeau, MO
Cancelled registrations · 88
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 = 'MO' AND d.registrant_city = 'CAPE GIRARDEAU' 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 = 'MO' AND d.registrant_city = 'CAPE GIRARDEAU' 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.
N7429CBlazing Wings 50% ULTIMATE · S/N PWC 0001N126PJFarquhar John PJ-1000 · S/N 0001N5830VSchweizer SGS 1-26B · S/N 265N5647DBeech E18S · S/N BA-364N453SEEaa Chapter 453 BREEZY · S/N RLU-1N45746Allen B-8M · S/N JBA-1N9034MLangford Don TANDEM AIR BIKE · S/N AB209AMTN7404ECessna 210 · S/N 57104N548BDCrowe John T BEDE 5B · S/N 548N114XXRockwell International 114A · S/N 14511N40TJWright-Thomas EAA BIPLANE P-2 · S/N 001N43043Taylorcraft BC12-D · S/N 6702N4596ECessna A185F · S/N 18503807N71482Luscombe 8A · S/N 2909N45726Sikorsky H-34J · S/N 56-4307N555ACBeech 58 · S/N TH-12N4884VBellanca 17-30 · S/N 30149N8706HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1481N4353YPiper PA-32-301 · S/N 32-8406010N4092LRaven S55A · S/N S55A-1016N8042QCessna 421B · S/N 421B0042N571DDBeech H-18 · S/N BA714N6939HCessna 172M · S/N 17265655N48426Grumman Acft ENG Cor-Schweizer G-164A · S/N 1635N759AFCessna 182Q · S/N 18265833N6346HCessna 182R · S/N 18267886N732NHCessna U206G · S/N U20604701N7038SCessna 150H · S/N 15067738N6461DCessna 172N · S/N 17272812N5349UCessna U206G · S/N U20605230N5557ECessna 172N · S/N 17271889N4824ECessna A185F · S/N 18503882N4951UCessna U206G · S/N U206-05175N5305UCessna U206G · S/N U20605186N733EXCessna U206G · S/N U20604763N739HLCessna 172N · S/N 17270555N48839Cessna 152 · S/N 15280995N732EGCessna U206G · S/N U20604664N8533QCessna A185F · S/N 18503727N1426ECessna 172N · S/N 17270994N739AACessna 172N · S/N 17270379N739UHCessna 172N · S/N 17270813N739YDCessna 172N · S/N 17270905N739EBCessna 172N · S/N 17270475N739PZCessna 172N · S/N 17270709N739AECessna 172N · S/N 17270383N49051Cessna 152 · S/N 15281123N738MDCessna 172N · S/N 17270077N738PZCessna 172N · S/N 17270143N69MPAmerican AA-1 · S/N AA1-0104
Back to Cape Girardeau, MO