Overland Park, KS
Registered aircraft · 189
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 = 'KS' AND g.registrant_city = 'OVERLAND PARK' 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 = 'KS' AND g.registrant_city = 'OVERLAND PARK' 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.
N101ZLCameron Balloons ZL-56 · S/N 6571N1061TNew Piper PA-46-500TP · S/N 4697274N1110VCirrus Design SR22T · S/N 10006N112ATAcecore NEO · S/N NEOX8NLXL34N1147HPiper PA-32R-300 · S/N 32R-7780139N120ATUnmanned Systs & Solutions LE1400Z · S/N 0A043D9A48N121FBGrumman Aircraft ENG G-111 · S/N 51-7249N127KHAero Commander 500-B · S/N 500B-1027-38N131JTAero Commander 500-B · S/N 1468-166N1406GDJI AGRAS T40 · S/N 64TBK8L001008QN14659Dehavilland TIGER MOTH DH 82A · S/N A17-659N151DKDanny L Marcy ONEX · S/N ONX0151N1581WBeech V35B · S/N D-9352N159BPiper PA-23-250 · S/N 27-7754047N1606FFirefly Balloons 2010 FIREFLY 5 · S/N F5-2010N1726EAeronca 7AC · S/N 7AC-5291Sale reportedN1747TPiper PA-28-140 · S/N 28-7125065N17GCzech Sport Aircraft A S SPORTCRUISER · S/N C0613N1801MBeech F33A · S/N CE-953N1802KLuscombe 8E · S/N 4529N182WKCessna 182P · S/N 18261257N188GTSocata TB-20 TRINIDAD · S/N 2048N18DKAlisport SILENT-IN · S/N 038N1934ZCessna 150C · S/N 15059734N1947JStinson 108 · S/N 108-2291N195JACessna 195B · S/N 7504N1986RGulfstream Aerospace GIV-X (G450) · S/N 4263N19988Cessna 172M · S/N 17260915N200ZCAmerican Champion 8KCAB · S/N 1187-2020N2025RIai GULFSTREAM G280 · S/N 2303N20389Cessna 172M · S/N 17261249N20405Cessna 172M · S/N 17261264N2043WCameron Balloons US V-77 · S/N 5399N2119SCameron Balloons US Z-77 · S/N 6541N219DPiper PA 46-350P · S/N 4636209N2235SCessna T210L · S/N 21061180N2260PPiper PA-23 · S/N 23-870N23BQAero Commander 500-B · S/N 500A-1065-46N23XUCirrus Design SR22 · S/N 8633N244DACessna 172M · S/N 17261294N256FKDJI AGRAS T40 · S/N 64TBK7H00100TTN2570MPiper PA-12 · S/N 12-921N261ERAero Commander 500-B · S/N 1362-133N26CSBeech A36 · S/N E-2814N28304Grumman American Avn. AA-5B · S/N AA5B0541N2851HSchweizer SGS 1-35 · S/N 51N28LEPiper PA-28R-200 · S/N 28R-7635253N2922JCessna 150G · S/N 15065722N295ATUnmanned Systs & Solutions LE1400Z · S/N 0A0435F690N300ZZEmbraer Executive EMB-505 · S/N 50500663
Back to Overland Park, KS