Kansas City, MO
Cancelled registrations · 727
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 = 'KANSAS 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 = 'KANSAS 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.
N314STBoeing 757-225 · S/N 22211N529AUBoeing 737-3B7 · S/N 24411N846KWBoeing 777-219 · S/N 34379N418USBoeing 737-401 · S/N 23985N430XABoeing 737-484 · S/N 25430N538CCBoeing 737-48E · S/N 25772N458UWBoeing 737-4B7 · S/N 25022N531AUBoeing 737-3B7 · S/N 24478N440USBoeing 737-4B7 · S/N 24811N319CJTextron 182T · S/N 18283187N841KWBoeing 777-246 · S/N 32891N8217DBeech 95 · S/N TD47N142DSSchaefer David W VANS RV-6A · S/N 60319N953KWBoeing 767-3Y0 · S/N 24953N741LKDJI PHANTOM 3 PROFESSION · S/N P78DCL17070833N670NWDJI INSPIRE 1 · S/N W21ACJ23010757N674EMDJI INSPIRE 1 · S/N W13DCA15020088N3234ECessna 172N · S/N 17271476N43HQDiamond Aircraft Ind DA 42 NG · S/N 42.N043N45HQDiamond Aircraft Ind DA 42 NG · S/N 42.N045N63HQDiamond Aircraft Ind DA 42 NG · S/N 42.363N27HQDiamond Aircraft Ind DA 42 NG · S/N 42.427N42HQDiamond Aircraft Ind DA 42 NG · S/N 42.N042N64HQDiamond Aircraft Ind DA 42 NG · S/N 42.364N4038CBalloon Works FIREFLY 7 · S/N 7807N895BTThompson Brian G CHALLENGER II · S/N CH2-0217-2912N77CLockheed 1329-25 JETSTAR II · S/N 5232N34WRLockheed 1329-25 JETSTAR II · S/N 5207N41CXMcdonnell Douglas DC-8-62F · S/N 46129N7718KPiper PA-20 · S/N 20540N87JPCessna 150F · S/N 15062232N2716MPiper PA-12 · S/N 12-1214N73396Fairchild M-62A · S/N FC227N9754HFairchild M-62A · S/N FV119N820XDonnelly Mitch QUICKSILVER SPRINTII · S/N 2116N25050Rayner Pusher 1A · S/N 155N776NA3D Robotics SOLO · S/N S111A5605787N34741Rearwin 180F · S/N 1551N83961Aeronca 7AC · S/N 7AC2647N196KCDassault FALCON 2000 · S/N 195N75026Consolidated Vultee SNV-1 · S/N 8920N3609TAerostar International RAVEN S57-A · S/N S57A-3080N94MGDehavilland DHC-6-200 · S/N 45N6518BMooney M20A · S/N 1185N84619Aeronca 7AC · S/N 7AC-3329N7605BStinson L-5G · S/N 45-34992N437DPPurnell Carl Daniel JR VANS RV-4 · S/N 2501N232DLLemons Richard L FOKKER DR 1 · S/N 232N99771Engineering & Research ERCOUPE 415-C · S/N 2394N65446Consolidated Vultee BT-13A · S/N 3048
Back to Kansas City, MO