Crystal, MN
Cancelled registrations · 564
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 = 'MN' AND d.registrant_city = 'CRYSTAL' 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 = 'MN' AND d.registrant_city = 'CRYSTAL' 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.
N72794Cessna 140 · S/N 9980N800YACamille E Patch CALIDUS · S/N C00308N7254LAmerican AA-1A · S/N AA1A-0454N8618EPiper PA-28-140 · S/N 28-7625142N8880PPiper PA-24-260 · S/N 24-4339N2056VCessna 120 · S/N 14269N5171BCessna 152 · S/N 15283787N12YTAmerican AA-1A · S/N AA1A-0376N2240LBeech C23 · S/N M-1888N334BAAerotechnik L-13 SEH VIVAT · S/N 940517N3805HErcoupe 415-CD · S/N 4506N3087LCessna 310J · S/N 310J0087N1953BLuscombe 8A · S/N 6380N592JJabiru USA Sport J250-SP · S/N 412N12RXRockwell International 112 · S/N 270N7311TCessna 172A · S/N 46911N75074Piper PA-28-151 · S/N 28-7615245N7FJJustice Frank K VANS RV-6A · S/N 22226N519RCGill Charles D S-21 OUTBOUND · S/N 09210202N5753GCessna 150K · S/N 15071253N8428JCessna 150G · S/N 15066328N50730Cessna 150J · S/N 15069514N76646Cessna 120 · S/N 11086N310SCessna 310D · S/N 39173N990RTTaylor Richard T RV6A · S/N 24490N1557SHulse Steven T SONEX · S/N 1557N55381Piper PA-28-140 · S/N 28-7325389N5511WPiper PA-28-160 · S/N 28-599N411RDPiper PA-22-150 · S/N 22-5234N4524RPiper PA-28-140 · S/N 28-21226N8014GCessna 177RG · S/N 177RG0014N6832NMooney M-20G · S/N 680111N929RSKruleski Chet M ZODIAC 601XL · S/N 6-5357N33114Piper PA-28-180 · S/N 28-7505123N7437GCessna 172K · S/N 17259137N9619HCessna 172M · S/N 17266269N40JPPrevost James R RV-6 · S/N 20581N8020LCessna 172H · S/N 17256220N7615LLake LA-4 · S/N 388N423KAeropro CZ A220 · S/N 431 14N510WBBennett Wilbur D ACROSPORT II · S/N 510N7962ZCessna 150C · S/N 15060062N11447Cessna 150L · S/N 15075429N266AMAircraft Mfg & Development CH 2000 · S/N 20-1052N4221Cessna 172RG · S/N 172RG0019N42998Piper PA-28-161 · S/N 28-8316063N711HBCessna 310P · S/N 310P0096N8414SCessna 182H · S/N 18256514N33005Piper PA-28-151 · S/N 28-7515288N624XPHoward C Jacquart RV6A · S/N 22369
Back to Crystal, MN