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.
N735MCCessna 182Q · S/N 18265523N737KSCessna 172N · S/N 17269482N7476GCessna 172K · S/N 17259176N7507ASchweizer 269C · S/N S1297N76856Cessna 120 · S/N 11290N7708PPiper PA-24 · S/N 24-2920N777EXPiper PA-28-151 · S/N 28-7515039N787MWBellanca 7ECA · S/N 1177-76N7906RBeech D55 · S/N TE-686N79196Cessna 172K · S/N 17257950N7963CPiper PA-28-181 · S/N 28-7690093N7CYCessna T337G · S/N P3370086N10RLBeech 58P · S/N TJ-340N12334Cessna 172M · S/N 17261934N1282XMooney M20E · S/N 155N13608Cessna 172M · S/N 17262880N136ZPPlumery Charles G MUSTANG II · S/N 2153N1400YCessna 172C · S/N 17249100N143NDPiper PA-28-161 · S/N 2841135N146FAPiper PA-28-161 · S/N 28-8116170N1516DCessna 195A · S/N 7738N15833Piper PA-28-180 · S/N 28-7305158N1861TPiper PA-28-140 · S/N 28-7225012N1924ZCessna 150C · S/N 15059724N19VCVictor M Cordero RV-9A · S/N 90319N206SSCessna TU206G · S/N U20606941N2180QCessna 177RG · S/N 177RG0580N2226FPiper PA-28-161 · S/N 28-7916189N2327ZBeech 23 · S/N M-29N245LSFlight Design CTLS · S/N F-08-05-12N2466JCessna 150G · S/N 15065566N252FFleming THORP T-18 · S/N 242N2781TBeech 35-C33 · S/N CD-1096N299BHJones Ronald C BEARHAWK · S/N 064-121-122-930N30537Cessna 177A · S/N 17701309N306SCCzech Sport Aircraft A S SPORTCRUISER · S/N P1001099N3111ACessna 170B · S/N 25755N3131VBeech 35 · S/N D-558N3156KMaule MX-7-160 · S/N 19036CN31698Piper PA-28R-201T · S/N 28R-7803296N320JCCessna 320E · S/N 320E-0085N32150Piper PA-28-180 · S/N 28-7505029N3344YCessna 182E · S/N 18254344N3379ECessna 172N · S/N 17271525N3432RCessna 182L · S/N 18258732N35140Cessna 177B · S/N 17702228N3521XMooney M20F · S/N 670059N37575Cessna 310R · S/N 310R1207N3854TPiper PA-28R-180 · S/N 28R-30176N38951Piper PA-28-161 · S/N 28-7716296
Back to Crystal, MN