Skip to content

Registered aircraft · 897

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 ('8190104', '8190111')
  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 ('8190104', '8190111')
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.

N37096Lehner Christopher E · Battle Ground, WABuilt 1941 · S/N 1757 N39012Gregg Ray A · Rangely, COBuilt 1941 · S/N 1773 N39028Registration Pending · Midland City, ALRegistration pendingBuilt 1941 · S/N 1789 N39034Anderson Mark A · Bates City, MOS/N 1795 N39041Pearsall David N · New Milford, CTBuilt 1941 · S/N 1802 N39078Stringer Gregory A · Egg Harbor Twp, NJBuilt 1941 · S/N 1839 N39079Christy Ronald · Lake City, MIS/N 1840 N39087Wolford Phillip J · Abingdon, ILBuilt 1941 · S/N 1848 N40SDFlying S Airventures LLC · San Antonio, TXBuilt 1948 · S/N 6339 N40VSDale David J · North Fort Myers, FLBuilt 1940 · S/N 1306 N41933Wilkie David J · Nashua, NHBuilt 1941 · S/N 1894 N41958Brown Jeffrey D · Saint Cloud, MNBuilt 1941 · S/N 1919 N41961Murray Gregory T · Napa, CABuilt 1942 · S/N 1922 N45404Denny Mark J · Battlefield, MOBuilt 1945 · S/N 1931 N45405Pierce James C · Tallahassee, FLBuilt 1945 · S/N 1932 N45410May Michael S · Axtell, NEBuilt 1945 · S/N 1937 N45411Sikkel Robert M · Bucksport, MEBuilt 1945 · S/N 1938 N45416Mckillop Bruce W · Rural Valley, PABuilt 1945 · S/N 1943 N45419Belnap Bobby R · Vale, ORBuilt 1945 · S/N 1946 N45425O Brien A Scott · Santa Rosa Valley, CABuilt 1945 · S/N 1952 N45426Registered aircraftBuilt 1956 · S/N 1953 N45432Hansen Joseph L · Alden, IABuilt 1945 · S/N 1959 N45435Scholz Mark W · Atchison, KSBuilt 1945 · S/N 1962 N45463Burns Jeffery T · Independence, ORBuilt 1945 · S/N 1990 N45468Cornett John R Jr · Lexington, KYBuilt 1946 · S/N 1995 N45475Andraka Andrew M · Newport News, VABuilt 1946 · S/N 2002 N45481Turiak Ryan J · Lugoff, SCFirst renewal noticeS/N 2008 N45484Varvayanis Mark · Dryden, NYBuilt 1946 · S/N 2011 N45488Heitkotter Shari · Ridgecrest, CABuilt 1946 · S/N 2015 N45489Mumford Kenneth E · Kailua, HIS/N 2016 N45493Garringer David A · Colville, WABuilt 1946 · S/N 2020 N45494Bolton Derwin B · Jacksonville, TXBuilt 1946 · S/N 2021 N45499Almeida Gilbert M · Hilmar, CABuilt 1946 · S/N 2026 N45504Zazas James B · Carthage, NCBuilt 1946 · S/N 2031 N45514Mick Edward H · Glassboro, NJBuilt 1946 · S/N 2041 N45518Michael Jeffrey R · Port Orange, FLBuilt 1946 · S/N 2045 N45519Day Wayne E · Des Moines, IABuilt 1946 · S/N 2046 N45527Reed Gretchen M · Madison, OHBuilt 1946 · S/N 2054 N45532Wall Craig M · San Antonio, TXBuilt 1946 · S/N 2059 N45534Jorgensen Ronald C · Askov, MNBuilt 1946 · S/N 2061 N45538Fiorello Stephen J · North Bellmore, NYBuilt 1946 · S/N 2065 N45544Ganther Kenneth R Jr · Olathe, KSBuilt 1946 · S/N 2071 N45549Beail Herschel D · Quincy, CAS/N 2076 N45555Phillips Robert L · Wilkesboro, NCS/N 2082 N45561Stevens Linda J · Caldwell, IDBuilt 1946 · S/N 2088 N45564Young Robert G · Naugatuck, CTBuilt 1946 · S/N 2091 N45567Passburg James O · Montpelier, VTBuilt 1946 · S/N 2094 N45569Go Leasing Co · Phillipsburg, KSBuilt 1946 · S/N 2096 N45577Glassburn Hugh S · Ephrata, WAS/N 2104 N45583Whitehead Keith A · Port Saint Joe, FLBuilt 1946 · S/N 2110

Back to Luscombe 8A