Crystal, MN
Cancelled registrations · 565
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.
N72GXRemos Acft Gmbh Flugzeugbau REMOS GX · S/N 275N2213WPiper PA-28RT-201 · S/N 28R-7918082N5321QCessna 150L · S/N 15073221N7447PPiper PA-24 · S/N 24-2636N233ABeech K35 · S/N D-5921N25SPPitts Special / Pesko S-1C · S/N 1-AN801PSCzech Sport PIPER SPORT · S/N P1001024N969CBCostruzioni Aeronautiche Tecna P2010 TDI · S/N 302/USN840HPiper PA-23-250 · S/N 27-4755N8560JCessna 150G · S/N 15066460N41724Piper PA-28R-200 · S/N 28R-7435212N8924SCessna 150F · S/N 15062224N2953PPiper PA-22-150 · S/N 22-3225N5849ZPiper PA-22-108 · S/N 22-9704N3610YCessna 210C · S/N 21058110N3709LCessna 172G · S/N 17253878N7838WPiper PA-28-180 · S/N 28-1855N919TSDutton Ray B CHALLENGER II · S/N CH2-1008-LSS-0154N15893Piper PA-28R-200 · S/N 28R-7335101N163VRVashon RANGER R7 · S/N 10156N282SVBellanca 17-30A · S/N 98-301026N55413Piper PA-28-235 · S/N 28-7310136N2474HEngineering & Research ERCOUPE 415-C · S/N 3099N341SSSawby Scott RV-6A · S/N 23894N9026PPiper PA-24-260 · S/N 24-4488N7767MMooney M20F · S/N 22-0023N955FZwart Dennis B SKY STAR VIXEN · S/N V95050032N387EJmmt VANS RV9A · S/N 90387N4539CBeech 77 · S/N WA-237N8242DBeech J35 · S/N D-5344N7782UCessna 172E · S/N 17251782N1929VCessna 172M · S/N 17263797N2120JPiper PA-28-161 · S/N 28-7916198N6040EBeech K35 · S/N D-6007N1887VCessna 140 · S/N 14067N33300Piper PA-34-200 · S/N 34-7450205N312PRProgressive Aerodyne SEAREY LSA · S/N 1127N4278XGardner E W KITFOX II · S/N 627N7298TCessna 172A · S/N 46898N730SCPiper PA-28-140 · S/N 28-7225546N8875PPiper PA-24-260 · S/N 24-4332N7286FPiper PA-28-140 · S/N 28-25199N141TNDiamond Aircraft Ind DA20-C1 · S/N C0653N25GGDiamond Aircraft Ind DA20-C1 · S/N C0664N5071BBeech F35 · S/N D-4377N131LCColvin Brent A RV-7 · S/N 71835N465DMRichard J Mottl HUMMEL H-5 · S/N 167N3282JCessna 150G · S/N 15065982N8258XCessna 172C · S/N 17248758N201ZMPipistrel Lsa S R L ALPHA TRAINER · S/N 913 AT 912 LSA
Back to Crystal, MN