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

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 = 'TN' AND g.registrant_city = 'COLUMBIA' 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 = 'TN' AND g.registrant_city = 'COLUMBIA'
  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 = 'TN' AND g.registrant_city = 'COLUMBIA'
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.

N110NXSmith Glen D ONEX · S/N ONX0110Built 2016 · Smith Glen D N112XBeech V35 · S/N D-8121Built 1966 · Air Corriente LLC N1137KSilvaire LUSCOMBE 8A · S/N 3864Built 1946 · Self Edwin C N13325Stinson VULTEE V-77 · S/N 77-164Brown Michael D N17286Piper PA-32-300 · S/N 32-40899Pride Terence E N22087Luscombe 8A · S/N 909Built 1939 · Webster David Ht N25396Silvaire LUSCOMBE 8A · S/N 1263Built 1940 · Self Edwin C N28243Gulfstream American AA-5B · S/N AA5B0961Built 1978 · Newsum Robert G N28610Grumman American Avn. AA-5B · S/N AA5B0677Built 1977 · Brown Ryan O N28632Luscombe 8C · S/N 1371Webster David Ht N3463BBeech D35 · S/N D-3689Built 1953 · Beveridge Brothers LLC N370KWWright Khris L RANS S-21 · S/N 03240370Wright Khris L N414TFCessna 414A · S/N 414A0676Built 1981 · Blue Sky Aviation LLC N4TACessna 172M · S/N 17262298Built 1973 · Columbia Aviation Inc N507AGDJI AGRAS T40 · S/N 52LBK6R0001005AEngland Wayne N5471NCessna 182R · S/N 18267741Built 1980 · Riley Aviation LLC N5481QCessna 150L · S/N 15073381Smith Glen D N588DFVans RV-12 · S/N 120336Built 2011 · Shade Neal Martin N697CCirrus Design SR22 · S/N 0443Mrc Aviation LLC N70722Nelson Jerry A CH 601 XL · S/N 64576Geiling David G N759HLCessna 182Q · S/N 18266006Built 1977 · Ruddle Thomas S N7784FCessna 150F · S/N 15063884Built 1966 · Self Edwin C N78TJCessna 525 · S/N 525-0864Built 2015 · Kcs Aviation LLC N83DRDausch Douglas J SONERAI II · S/N 1177LBrooks David J N8954DPiper PA-22-160 · S/N 22-6117Sandstead Russell L N9149GHoffman Duane G KOLB FIRESTAR II · S/N FS359Built 1996 · Underwood Wayne R N92584Cessna 182N · S/N 18260270Built 1970 · Buckner Walter N9840YChampion 7FC · S/N 7FC-436Built 1961 · Brown Michael D N9945HCessna 182R · S/N 18268133Built 1981 · Cbw Holdings LLC N9955TCessna 182D · S/N 18253055Built 1960 · Wheeler Aaron T

Back to Columbia, TN