Kansas City, MO
Registered aircraft · 230
Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.
Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_state = 'MO' AND g.registrant_city = 'KANSAS CITY' ORDER BY g.n_number"
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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_state = 'MO' AND g.registrant_city = 'KANSAS CITY' ORDER BY g.n_number
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.
N10112Lockheed L-1011-385-1 · S/N 193L1064N110PKAirbus S A S A380-841 · S/N 0054N114PJBeech 58P · S/N TJ-410N115PKAirbus S A S A380-841 · S/N 0088N120VWCessna 120 · S/N 12936N121RWBeech F33A · S/N CE-296N124MPMark O Pierce CHUMP · S/N 001N13659Cessna 172M · S/N 17262919N1419TPiper PA-28R-200 · S/N 28R-7235283N1436UCessna 172M · S/N 17267103N145SMartin 404 · S/N 14142N14702Bellanca 17-31A · S/N 74-32-136N1489TPiper PA-32-260 · S/N 32-7200042N149XABoeing 737-484 · S/N 27149N151AROliver Robert K RV-8A · S/N 82290N1541ZBeech 35-B33 · S/N CD-421N161PAEmbraer-Empresa Brasileira De EMB-500 · S/N 50000169N1650JPiper PA-28-140 · S/N 28-24043N1660HPiper PA-28-161 · S/N 28-7716037N1665Baslee Robert W OLD AIRCRAFT REPLICA · S/N 001N1711WCessna 182J · S/N 18257108N180CCPiper PA-28-180 · S/N 28-7505048N18137Lockheed 12A · S/N 1229N1865KCessna 560XL · S/N 560-6172N1910HHawker Beechcraft HAWKER 900XP · S/N HA-0190N1945Douglas DC3-G202A · S/N 3294N195KCDassault FALCON 2000EX · S/N 724N201NLMooney M20J · S/N 24-0273First renewal noticeN205AKBrown Henry JR KITFOX IV · S/N C9602-0144N210FCessna T210G · S/N T210-0244N2120LBeech 95-B55 (T42A) · S/N TC-1985N2169FPiper PA-28-181 · S/N 28-7990222N219TFGulfstream Aerospace GIV-X (G450) · S/N 4292N21GVCessna 525B · S/N 525B0301N21PSStratman Paul RV-6A · S/N 25733N2238ECessna 172N · S/N 17271199N238MJMatthew G Rivard RV-10 · S/N 42596N2435MPiper PA-28-181 · S/N 28-7890253N24663Beech C23 · S/N M-1425N2597GBalloon Works FIREFLY 8B-15 · S/N F8B-474N269WBNorth American-Maslon SNJ-4 · S/N 26992N2851ZPiper PA-28-161 · S/N 28-7916479N291JMAirbus S A S A380-841 · S/N 0031N294ARBoeing 777-219 · S/N 29404N296JMAirbus S A S A380-841 · S/N 0036N299JSPiper PA-28-151 · S/N 28-7415313N301LEBell Helicopter Textron Canada 407 · S/N 54406N302LEBell Helicopter Textron Canada 407 · S/N 54418N305MLAvia Stroitel AC-5M · S/N 030N307MSDJI AGRAS T50 · S/N 63YBM4H0020041
Back to Kansas City, MO