Fargo, ND
Cancelled registrations · 189
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 = 'ND' AND d.registrant_city = 'FARGO' 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 = 'ND' AND d.registrant_city = 'FARGO' 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.
N2846SCessna 150G · S/N 150-66746N4949UCessna 210 · S/N 210-58649N3491MPiper PA-12 · S/N 12-2084N2063GCessna 182A · S/N 51363N2503VCessna 170 · S/N 18006N79294Aeronca L-16A · S/N 47-862AN79297Piper J3C-65 · S/N 10037N2418EAeronca 7AC · S/N 7AC-5997N6890FCessna 150F · S/N 15063490N5948TCessna 150D · S/N 15060648N77994Luscombe 8A · S/N 3721N84859Aeronca 7AC · S/N 7AC-3578N5881PPiper PA-24 · S/N 24-966N35751Piper J3C-65 · S/N 6589N2079BLuscombe 8A · S/N 6506N88636Piper J3C-65 · S/N 16264N9049KStinson 108-1 · S/N 108-2049N75196North American SNJ-3 · S/N 78-7279N64939Consolidated Vultee BT-13A · S/N 5557N79296Aeronca L-16A · S/N 7BCM-78N2106KLuscombe 8A · S/N 4833N3053MPiper PA-12 · S/N 12-1584N72772Cessna 140 · S/N 9955N29388Culver LCA · S/N 177N42168Piper J3C-65 · S/N 14403N2743HErcoupe 415-C · S/N 3368N2257HEngineering & Research 415-C · S/N 2882N98345Piper J3C-65 · S/N 18515N21833Piper J-3 · S/N 2630N85669Aeronca 7AC · S/N 7AC-4414N85165Aeronca 7AC · S/N 7AC3897N37844Culver LFA · S/N 348N80279Culver V · S/N V-198N34493Aeronca 65-LB · S/N LB14801N80056Culver V · S/N V-97N50193Fairchild M-62A · S/N T-41-626N16552Aeronca C-3 · S/N A-693N99992Ercoupe 415-C · S/N 2615N1427Central States Aero MONOCOUPE · S/N 7
Back to Fargo, ND