Registered aircraft · 29

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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 = 'SEDALIA' ORDER BY g.n_number

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 = 'SEDALIA'
  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 = 'SEDALIA'
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.

N1035EBellanca 7GCBC · S/N 983-77Built 1977 · Jobe Ronald G N141JCDJI AGRAS T40 · S/N 64TBK7H00100P9Christner Adam L N1990LSkelt CH LANCAIR 320 · S/N PFA 191-11865Built 2016 · Clearsound Hearing LLC N221CFPickens M/Hicks L VANS RV-9A · S/N 90507Built 2003 · Patterson Tim A N252YAviat A-1C-180 · S/N 3309Built 2018 · Ultimatetoweds LLC N258WQDJI AGRAS T20P · S/N 64UBL8100200FEMid-Mo Ag Drone Services LLC N280YSBingham Morss LANCAIR 320 · S/N BING-1Crabtree Martin L N302TMDJI AGRAS T40 · S/N 64TBL9600200ETMid-Mo Ag Drone Services LLC N37543Cessna 414A · S/N 414A0002Construction Solutions & Consulting LLC N39851Bellanca 17-31A · S/N 73-32-100Built 1972 · Kuhns Bart D N4622RPiper PA-28-140 · S/N 28-21372Built 1966 · Zimmerschield Paul T N521PEEmbraer Executive EMB-505 · S/N 50500922Built 2025 · Proaviation LLC N532DRPiper PA-32R-301T · S/N 3257060Built 1998 · Ellebracht Steve N58CXIai GULFSTREAM G280 · S/N 2246Built 2022 · Canon Aviation LLC N612HBeech E-55 · S/N TE-860Built 1972 · Clear Sound Hearing LLC N624MZStauffer ZODIAC 601XL · S/N 6-4999Built 2009 · Potts Ryan N6571UMooney M20C · S/N 2353Built 1962 · Crabtree Martin L N666TAAlbano JR Thomas J RV 8 · S/N 999Built 2014 · Edwards Mark A N6966GCessna 150L · S/N 15072466Built 1970 · Hotsenpiller Larry E N731DSCessna P210N · S/N P21000446Built 1979 · You And Me LLC N735TUCessna 182Q · S/N 18265678Built 1977 · Ferguson William R N7760KPiper PA-20 · S/N 20-594Built 1951 · Gleason Thomas K N785CWCessna 550 · S/N 550-0916Built 2000 · Construction Solutions & Consulting LLC N8403PPiper PA-24-250 · S/N 24-3659Built 1964 · Newell Douglas Bryon N87201Ercoupe 415-C · S/N 374Built 1946 · Yurasich Tom J N89754Cessna 140 · S/N 8803Built 1946 · Bentch Mark W N899RVPahnke Vernon A VANS RV-9A · S/N 90537Built 2006 · Crabtree Martin N95275Taylorcraft BC12-D · S/N 9675Magpie Aviation LLC N99NTBeech V35 · S/N D-8019Built 1965 · Edwards Mark A

Back to Sedalia, MO