Jefferson City, MO
Cancelled registrations · 45
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 = 'MO' AND d.registrant_city = 'JEFFERSON CITY' 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 = 'MO' AND d.registrant_city = 'JEFFERSON CITY' 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.
N601ZPAircraft Mfg & Development CH601XL · S/N 1-001SN314KADJI AGRAS T50 · S/N 1581F6BUB2359001014FN986KEDJI AGRAS T40 · S/N 1581F574B224S00101NVN402MCCessna 402C · S/N 402C1015N21380Firefly Balloons FIREFLY 7-15 · S/N F7-2061N701VZDavid Shell ZENITH CH701 · S/N 7-6687N2666HErcoupe 415-C · S/N 3291N8130APiper PA-28-161 · S/N 28-8016157N40388Balloon Works FIREFLY 7 · S/N 7819N877KCCirrus Design SR22 · S/N 3432N7524PCameron Balloons US N-65 · S/N 5792N9081YBalloon Works FIREFLY 7B-15 · S/N F7B-319N7858RBeech D55 · S/N TE-681N4499MBalloon Works FIREFLY 7 · S/N 7942N35722Cessna 172I · S/N 17256934N2598LBalloon Works FIREFLY 7-15 · S/N F7-827N7422LBalloon Works FIREFLY 8B · S/N F8B-031N7108VBalloon Works FIREFLY 7 · S/N F7-396N22CNPiper PA-31T1 · S/N 31T-7904049N563QCessna 150F · S/N 15061777N96MPBell 206B · S/N 3377N34SAmerican Eurocopter AS350B2 · S/N 4533N94149Supermarine/Vickers SPITFIRE MK IX · S/N 441N77MZKoonce John Paul VANS RV-7A · S/N 70459N94141Supermarine/Vickers SPITFIRE MK IX · S/N 424N24WFLearjet 24 · S/N 24-143N98MBCessna 500 · S/N 500-0054N34TMCessna 421B · S/N 421B0965N77MPBell OH-58A · S/N 72-21187N110SLBeech B90 · S/N LJ364N152KTThompson Kinnith W J24 WEEDHOPPER · S/N SN1522N98MPBeech B-55 · S/N TF14N25943Cessna 152 · S/N 15280871N5556WPiper PA-28-160 · S/N 28648N8944VCessna 172 · S/N 36844N555TTPiper PA-28-151 · S/N 287515241N66419Cessna 150M · S/N 15076034N90MPHughes 269A · S/N 1050413N5792MCessna 310P · S/N 310P-0092N5868ECessna 150 · S/N 17368N33722Aeronca 65-CA · S/N CA-12931N54880Consolidated L5 · S/N 75-132N73546Cessna T-50 · S/N 2849N48253Fairchild M-62A · S/N T42-3399N73528Howard DGA-15P · S/N 29486
Back to Jefferson City, MO