Registered aircraft · 23

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 = 'IN' AND g.registrant_city = 'LEBANON' 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 = 'IN' AND g.registrant_city = 'LEBANON'
  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 = 'IN' AND g.registrant_city = 'LEBANON'
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.

N105XBeech M35 · S/N D-6436Built 1960 · Saalwaechter John J N1253DCameron Balloons US C-100 · S/N 6382Built 2004 · Derado John N150LSCessna 150L · S/N 15074694Trout David Lee N15ZAMabis Thomas J ZENITH CH750 STOL · S/N 75-8798Mabis Thomas J N16566Piper PA-28R-200 · S/N 28R-7335164Schaumberg John N1694KLuscombe 8A · S/N 4421Built 1947 · Korman Nicholas N1951EChampion 7KCAB · S/N 81Built 1968 · Mcclure Steve N2039BHylio AG-272 · S/N 070222Becks Hybrids N2193ZFirefly Balloons GALAXY 8B · S/N GLX-1088BBuilt 2005 · Tsb Solutions LLC N2246CCessna 140 · S/N 8098Built 1946 · Korman Nicholas N25FHHarris Floyd R CHRISTEN EAGLE II · S/N HARRIS 0001Built 1986 · Thompson Bruce N277ADCameron Balloons Z-70 · S/N 6280Built 2001 · Derado John N3287FMooney M20F · S/N 670380Schaumberg John N403FNBalony Kubicek Spol Sro BB34Z · S/N 1407Tsb Solutions LLC N5568WPiper PA-28-160 · S/N 28-662Registration pending, pending cancellation N669TLRobinson Helicopter R66 · S/N 0906Built 2018 · Lily Logistics LLC N741NAHylio HYL-150 · S/N 17906110516Sale reported N816ABFantasy Sky Promotions FANTASY NINE-122 · S/N 116Built 2017 · Tsb Solutions LLC N905KMMossman Michael D ZENAIR CH 601 HD · S/N 6-3795Built 2004 · Mossman Michael D N940HWaco BSO · S/N A-145Built 1929 · Lozier Thomas S N9577HWaco CTO · S/N A-47Built 1929 · Lozier Thomas S N971TMMabis Thomas J VANS RV-9A · S/N 91512Built 2018 · Mabis Thomas J N9NCessna 182Q · S/N 18266518Built 1978 · Culley Terry L

Back to Lebanon, IN