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.

N71792Henley Charles D · New London, NCBuilt 1946 · S/N 3219 N71793Shields Toby J · Cato, NYBuilt 1946 · S/N 3220 N71800Miller Clyde D · Ionia, IABuilt 1946 · S/N 3227 N71801Williams Christopher N · Redwood Valley, CAS/N 3228 N71802Holbrook Joel P · Delta Junction, AKBuilt 1946 · S/N 3229 N71804Adams Terry D · Boerne, TXS/N 3231 N71806Cameron Thomas James · Stanchfield, MNBuilt 1946 · S/N 3233 N71813Burdick Leon J · Cambridge Springs, PABuilt 1946 · S/N 3240 N71814Collins Dennis M · Overgaard, AZBuilt 1946 · S/N 3241 N71816Clark Nikita C · Ontario, ORBuilt 1946 · S/N 3243 N71819Cuny John B · Carlsborg, WABuilt 1946 · S/N 3246 N71824Forberg Robert E · Hudsonville, MIBuilt 1946 · S/N 3251 N71825Tylenda John R · Bigelow, ARBuilt 1946 · S/N 3252 N71826Bemidji Aviation Services Inc · Bemidji, MNBuilt 1946 · S/N 3253 N71835Eads Timothy · West Linn, ORBuilt 1946 · S/N 3262 N71836Taildragger Adventures Of Madison LLC · Madison, WIBuilt 1946 · S/N 3263 N71845Kotranza Robert Roy · Houghton Lake, MIBuilt 1946 · S/N 3272 N71854Wings N Nuts Inc · Canandaigua, NYBuilt 1946 · S/N 3281 N71861Freudenberg Joseph B · Almira, WABuilt 1946 · S/N 3288 N71862Seward Douglas L · Burlington, WABuilt 1946 · S/N 3289 N71868Denly James E · Erie, COBuilt 1946 · S/N 3295 N71872Barlow Charles E · Morganton, NCBuilt 1946 · S/N 3299 N71875Laroche Susan L · Waukesha, WIBuilt 1946 · S/N 3302 N71883Flight Department LLC · Santa Paula, CABuilt 1946 · S/N 3310 N71891Emery Kyle Whitney · Mulberry, FLFirst renewal noticeBuilt 1946 · S/N 3318 N71892Cleveland Chris · Denver, COBuilt 1946 · S/N 3319 N71893Prough Ethan T · Godfrey, ILS/N 3320 N71895Kell Thomas G · Anchorage, AKBuilt 1946 · S/N 3322 N71901Langrell Sterling S · Woodburn, ORS/N 3328 N71918Schepis Sally A · Perry, MIBuilt 1946 · S/N 3345 N71919Professional Pilots Inc · Lowell, INBuilt 1946 · S/N 3346 N71923Gann Nick · Conway, MOBuilt 1946 · S/N 3350 N71928Singleton Bruce W · Grafton, OHBuilt 1946 · S/N 3355 N71929Norsworthy Cletus C · Media, PABuilt 1946 · S/N 3356 N71930Willis William P Trustee · New Palestine, INS/N 3357 N71931Araldi Suzanne R · Lakeland, FLBuilt 1946 · S/N 3358 N71932Swager Quentin D · Wrightwood, CAFirst renewal noticeBuilt 1946 · S/N 3359 N71937Wheeler William N · Seattle, WAS/N 3364 N71941Mckinsey Thane R · Laramie, WYBuilt 1946 · S/N 3368 N71942Distant Horizons LLC · Irondale, ALBuilt 1946 · S/N 3369 N71945Stake Ken C · Visalia, CABuilt 1946 · S/N 3372 N71954Shattuck Charles W III · Goshen, CTBuilt 1946 · S/N 3381 N71955Wilson Earl · Rockford, ILBuilt 1946 · S/N 3382 N71960Registration Pending · Lampasas, TXRegistration pending, pending cancellationS/N 3387 N71968Schrautemyer Albert Jr · Des Plaines, ILBuilt 1946 · S/N 3395 N71969Hagedorn Matthew J · Prineville, ORBuilt 1946 · S/N 3396 N71976Blessum Jay A · Minot, NDBuilt 1946 · S/N 3403 N71978Thompson Tommy Lee · Oakdale, CABuilt 1946 · S/N 3405 N71981Linville Raymond E · Carnesville, GABuilt 1946 · S/N 3408 N71986Green Dwayne · Santa Rosa, CABuilt 1946 · S/N 3413

Back to Luscombe 8A