Jackson, MS
Cancelled registrations · 160
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 = 'MS' AND d.registrant_city = 'JACKSON' 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 = 'MS' AND d.registrant_city = 'JACKSON' 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.
N351MSEurocopter Deutschland EC 135 T2+ · S/N 0823N19CSShivers BREEZY · S/N CBS-1N56564Grover Acft Corp/Coburn Fe JR J-3 KITTEN · S/N 01009N33305Piper PA-28R-200 · S/N 28R-7535131N2664NCessna 140 · S/N 12922N914RVDunlap Charles RV 4 · S/N 2462N8080DPiper PA-18A 150 · S/N 18-6070N368HCBeech H-18 · S/N BA-630N715JDBombardier BD-100-1A10 · S/N 20089N3814LCessna 172G · S/N 17253983N3137QCessna 182K · S/N 18258137N212RWPiper PA-34-220T · S/N 34-8133138N1053FPiper PA32-301FT · S/N 3232064N96303Taylorcraft BF · S/N 8603N495DMBeech C-45H · S/N AF-225N29806Taylorcraft BC12-D1 · S/N 2654N36694Piper PA-32RT-300T · S/N 32R-7887066N29192Aeronca 60-TF · S/N 2540TN1975MAeronca 7BCM · S/N 7BCM-92N4255HAgusta 206A · S/N 8082N700WMMccain William A SPECIAL · S/N 001N18170Cessna 150L · S/N 15073839N2484APiper PA-38-112 · S/N 38-78A0708N32EVNew Piper PA32-301FT · S/N 3232058N697EZBodne Jack B LONG-EZ · S/N 1589N4539JCameron Balloons US N-105 · S/N 5873N96824Taylorcraft BC12-D · S/N 9124N454AMDehavilland DH 114 HERON 2X · S/N 14063N7512YPiper PA-30 · S/N 30-576N62423Dehavilland CHIPMUNK DHC-1T10 · S/N C1-0588N4335Kellum CAVALIER 102.5 · S/N 1N66364Piper J3C-65 · S/N 9882N80397Cessna 172M · S/N 17266570N9166WPiper PA-28-235 · S/N 28-10845N33PXRobinson Helicopter R44 · S/N 1684N24FCCessna R172E · S/N R1720199N64681Pertuit EASYRISER · S/N 574N95PBEmbraer EMB-110P1 · S/N 110.330N2478SCessna R182 · S/N R18201342N3218FMooney M20E · S/N 670011N68394Beech C-45 · S/N 51-238N8881ABeech B35 · S/N D-2536N8059NPiper PA-28-140 · S/N 28-25307N74477Bellanca 14-13-2 · S/N 1590N7205DPiper PA-22-150 · S/N 22-5029N382BBeech D-50 · S/N DH-140N1238SSchweizer SGS 2-33A · S/N 220N3191DCessna 180 · S/N 31989N5PDBell H-13 · S/N 57-1829N447RSDouglas DC3A · S/N 4810
Back to Jackson, MS