Registered aircraft · 22

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

N146DASweeney Donald E PIETENPOL · S/N 001Scott Brent A N1824JSchweizer 269C-1 · S/N 0192Built 2005 · Cb Flying LLC N1859PBeech A36 · S/N E-1995Built 1982 · 1859p LLC N2632GCessna 182B · S/N 51932Built 1959 · Huey James M N27CBRepublic RC-3 · S/N 262Built 1947 · Huey Andrew G N3657LCessna 172G · S/N 17253826Built 1965 · Hollabaugh David S N3801CBeech A36TC · S/N EA-167Built 1980 · Danuser Aviation LLC N4007AHead Balloons AX7-77 · S/N 428Built 2013 · Graham Gerald T N4182WPiper PA-32-300 · S/N 32-40264Built 1967 · November Four One Eight Two Whiskey LLC N4556APiper PA-22-150 · S/N 22-3867Scott Brent A N5138MBeech C24R · S/N MC-579Built 1978 · Dl Squared LLC N6231BParker Allen W CHALLENGER II · S/N 1273Built 1998 · Parker Allen W N653TBBeech 200 · S/N BB586Built 1979 · Callaway Air LLC N6652KDowner REPUBLIC RC-3 · S/N 929Built 1947 · Huey Andrew N6754YPiper PA-23-250 · S/N 27-4083Built 1968 · November Nine One Four Eight Juliet LLC N6971YPiper PA-23-250 · S/N 27-4338Built 1969 · November Nine One Four Eight Juliet LLC N75187Piper PA-28-151 · S/N 28-7615266Built 1976 · N75187 LLC N7574BChampion 7EC · S/N 7EC-613Built 1957 · Huey Andrew G N791WCubcrafters CC11-160 · S/N CC11-00368Built 2015 · Davis Joseph R N882DStinson 108-2 · S/N 108-2882Built 1947 · Morgan Lloyd Robert N9050WPiper PA-28-235 · S/N 28-10644Built 1965 · Suedmeyer Kevin R DBA N9148JPiper PA-28-180 · S/N 28-3203Built 1966 · November Nine One Four Eight Juliet LLC

Back to Fulton, MO