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.

N77869Briere Mark E · Mims, FLBuilt 1946 · S/N 3596 N77874Panepinto Lane P · Lafitte, LAS/N 3601 N77876Borre Alan D · Palmyra, WIBuilt 1946 · S/N 3603 N77881Ramsey Cody M · Willits, CABuilt 1946 · S/N 3608 N77883Shank Ronald D · Greensburg, KSBuilt 1946 · S/N 3610 N77887Hannemann James R · Mercer, WIBuilt 1946 · S/N 3614 N77890Johnson Rodney C · Wheaton, MNBuilt 1946 · S/N 3617 N77893Slunecka Wendell J · Gering, NEBuilt 1946 · S/N 3620 N77895Woodard Mark A · Hookstown, PABuilt 1946 · S/N 3622 N77901Boese Erich A · Oakdale, CABuilt 1946 · S/N 3628 N77903Twibell David J · Ceresco, NEBuilt 1946 · S/N 3630 N77905Gajewski Lillia M · Billings, MTBuilt 1946 · S/N 3632 N77906Smith Steve G · Powell, TNBuilt 1946 · S/N 3633 N77909Ziegler Gerald K · Columbiana, OHBuilt 1946 · S/N 3636 N77917Wieneke Steven J · Phoenix, AZBuilt 1946 · S/N 3644 N77918Dewitt Machenical And Services LLC · Sycamore, ILBuilt 1946 · S/N 3645 N77923Hamilton Mark D · Thomasville, GABuilt 1946 · S/N 3650 N77925Miller Rondo T · Coon Rapids, MNS/N 3652 N77926Kyle Tim Eugene · Wenatchee, WABuilt 1946 · S/N 3653 N77927Rickard Donald S · Florence, ALS/N 3654 N77929Boursaw Ward L · Concrete, WABuilt 1946 · S/N 3656 N77933Wells Nicholas M · Holdrege, NES/N 3660 N77935Glassburn Hugh S · Ephrata, WAS/N 3662 N77937Harrison Mark S · Berrien Center, MIBuilt 1946 · S/N 3664 N77939Dillahunty Chris D · Fresno, CABuilt 1946 · S/N 3666 N77942Marburg Loren C · Etiwanda, CABuilt 1946 · S/N 3669 N77946Gramke John M · Ukiah, CABuilt 1946 · S/N 3673 N77948Keys Trevor · Chehalis, WABuilt 1946 · S/N 3675 N77950Gottschall Kenneth Lee III · Santa Paula, CAS/N 3677 N77956Hayllar Russell W · Newnan, GABuilt 1946 · S/N 3683 N77971Ricol Aviation LLC · Naples, FLS/N 3698 N77986Urash Richard M · Americus, GABuilt 1946 · S/N 3713 N77988Gurr James E · Alden, MIBuilt 1946 · S/N 3715 N77989Lennon David K · Hampton, NHBuilt 1946 · S/N 3716 N77995Vintage Adventures Inc · Ocala, FLBuilt 1946 · S/N 3722 N77997Michel Ralph E · Saint James, MOBuilt 1946 · S/N 3724 N801DRLuy Jonathan C · Sutter Creek, CABuilt 1948 · S/N 5972 N8062CLazypp Et Al LLC · Kalispell, MTBuilt 1947 · S/N 5423 N8218BAce Aeromotive Inc · Miami, FLBuilt 1946 · S/N 4028 N8382Willis William P Trustee · New Palestine, INS/N 6331 N84135Blackburn Richard L · Pendleton, ORS/N 5845 N88581Glista James T · Enfield, CTS/N 1410 N90533Blake Aaron T · Selma, INBuilt 1946 · S/N 3817 N9192FOwens Lewis F · Fillmore, INS/N 2805 N93CKBeck Larry A · Arkdale, WIBuilt 1946 · S/N 4036 N97401Durossette Darryl Z · Eugene, ORBuilt 1946 · S/N 4067 N99LCMartens Gary F · Stanley, NDBuilt 1940 · S/N 1227

Back to Luscombe 8A