Goodland, KS
Registered aircraft · 30
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 = 'GOODLAND' 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 = 'GOODLAND' 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.
N1861LBeech 95-B55 (T42A) · S/N TC-1964N195BACessna 195B · S/N 16069N195CNCessna 195B · S/N 16163N1971FCessna 172N · S/N 17273059N2110BStits Playboy SA3B · S/N P-463N24921Piper J4A · S/N 4-705N271LAAir Tractor AT-802A · S/N 802A-0471N3606KPiper J3C-65 · S/N 22296N36KDRobinson/Rogers KELLY-D · S/N 33N402VAir Tractor AT-402A · S/N 402A-1050N40889Hunter John R A-26 VULCAN · S/N SA-26-008N44406Buckeye DREAM MACHINE · S/N 4860N5057JCessna T310R · S/N 310R0177N54LFFrank Lorin L RV-8A · S/N 81435N6000YAir Tractor AT-401B · S/N 401B-0983N602FAAir Tractor AT-602 · S/N 602-1256N605TAAir Tractor AT-602 · S/N 602-1262N632DWStanish-Joseph MUSTANG-II · S/N 310N699JBBaker James W RV-6 · S/N 21662N76521Cessna 140 · S/N 10953N7672BBellanca 14-19-2 · S/N 4023N78JGBeech C35 · S/N D-3254N8018TYakovlev YAK 18T · S/N 22202040093Registration pendingN8063CPiper PA-28-181 · S/N 28-7690100N8175EMooney M20A · S/N 1446N876TBJust Love To Fly RV-6 · S/N 20363N8887CPiper PA-22-135 · S/N 22-1470N89GCQuicksilver SPORT 2S · S/N GC01N9108MCessna 182P · S/N 18264680N9197VAir Tractor AT-401 · S/N 401-0944
Back to Goodland, KS