Skip to content

Registered aircraft · 25

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('8190116')
  ORDER BY 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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('8190116')
ORDER BY 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.

N1576BBennett Robert M · Felton, DEBuilt 1948 · S/N 6203 N1583BColvin Clu D · Big Cabin, OKBuilt 1948 · S/N 6210 N1589BWomack Thomas G · Lonoke, ARBuilt 1948 · S/N 6216 N1591BPerry Jim · Monroe, WAS/N 6218 N1592BMcneill Daniel A · Placerville, CAS/N 6219 N1818BWilliams Timothy W · West Monroe, LABuilt 1948 · S/N 6245 N1822BRidgeway Beata 1 · Valewood Rd, ILBuilt 1948 · S/N 6249 N1825BKruse Adam L · Weiser, IDS/N 6252 N1827BWakefield John DBA Skyways · Cooperstown, NDBuilt 1948 · S/N 6254 N1848BSouthard Hunter · Knob Noster, MOS/N 6275 N1859BKruse Adam L · Weiser, IDS/N 6286 N2058BVanreeth Philip J · Woodstock, ILBuilt 1948 · S/N 6485 N2123BLovell Mark S · Templeton, CABuilt 1949 · S/N 6550 N2124BKell Thomas G · Anchorage, AKS/N 6551 N2140BColvin Clu D DBA · Big Cabin, OKBuilt 1949 · S/N 6567 N2152BBolog Keith F · Kenosha, WIS/N 6579 N2208BSorenson Fred C · Las Vegas, NVBuilt 1949 · S/N 6635 N2214BWilhite John R · Red Oak, TXBuilt 1949 · S/N 6641 N2216BGrass Brian S · Ocala, FLBuilt 1949 · S/N 6643 N2246BBendelius Robert J · Accord, NYBuilt 1949 · S/N 6673 N2260BFederal Aerial Applicators LLC · Wilmington, DEBuilt 1949 · S/N 6687 N2261BObie Edgar L · Chinook, MTBuilt 1949 · S/N 6688 N454LELinden Thomas D · Mcfarland, WIBuilt 1949 · S/N 6599 N478TFLuscombe Observer Wp LLC · Dover, DES/N 6691 N48TFFreeman Stephen K · Bartlett, TNBuilt 1948 · S/N 6274

Back to Luscombe T-8F