Olathe, KS
Registered aircraft · 134
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 = 'OLATHE' 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 = 'OLATHE' 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.
N1079HPiper PA-28-140 · S/N 28-7725131N1083EBellanca 8KCAB · S/N 307-77N1129SRaytheon 58 · S/N TH-1812N127EAviat A-1B · S/N 2146N15512Beech A36 · S/N E-2486N1561VCessna 172M · S/N 17263664N161PBCanadair CL-601-3A · S/N 5069N176LFBeech A36 · S/N E-1052N182MBCessna 182P · S/N 18264405N18PKAerotek PITTS S-2B · S/N 5018N202JCQuicksilver SPORT 2S · S/N 0105N2104MPiper J3C-65 · S/N 20886N212AJPearse Arnold J RV-3 · S/N 575N219RVMcguff Thomas M RV-9A · S/N 91521N222GLRaytheon G36 · S/N E-3763N225WDDavid J Svajda VANS RV-6 · S/N 22209N2307QBeech 23 · S/N M-367N2395XCessna 182H · S/N 18256295N23RMBeech S35 · S/N D-7311N2483DCessna 170B · S/N 20635N2505RPiper PA-28-180 · S/N 28-5638N262RMMiller Robert VANS RV-8 · S/N 80153N2662FCessna 182S · S/N 18280337N275TBSocata TB-20 TRINIDAD · S/N 1159N284HPiper PA-28-181 · S/N 2881480N2858WBeech E-55 · S/N TE-927N288KMBeech B200 · S/N BB-1508N300WBCessna 560 · S/N 5600271N3037KPiper PA-28RT-201T · S/N 28R-7931031N3112HErcoupe 415-C · S/N 3737N3165YCessna 182E · S/N 18254165N3291GBalloon Works FIREFLY 7-15 · S/N F7-1045N3370SCessna A185F · S/N 18502281N3464XMooney M20E · S/N 1144N34AQBeech A45 · S/N CG112N34KPPerkins Kenneth E PIETENPOL · S/N 6N3639FNorth American SNJ-6 · S/N 112148N38315Piper PA-28-140 · S/N 28-7725275N38RVMallory Steven L RV-4 · S/N 1799N3NBPiper PA-32R-300 · S/N 32R-7780277N4044QPiper PA-28-236 · S/N 28-7911109N408RVS2rv RV 8 · S/N 81144N413MRCirrus Design SR20 · S/N 2447N4174FPiper PA-28-151 · S/N 28-7715008N4247SAvions Mudry ET Cie CAP 10B · S/N EPC-170N430TACessna 560 · S/N 560-0533N437MBPiper PA-28-181 · S/N 2881597N440PCCowles Peter D FREEFLIGHT ULTRA II · S/N PC001-2024N447DLPiper PA 46-350P · S/N 4636436N45544Luscombe 8A · S/N 2071
Back to Olathe, KS