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.

N1946SLento LLC · Deer Park, WABuilt 1946 · S/N 3038 N1955BWright James A · Litchfield, ILBuilt 1948 · S/N 6382 N1957BPendleton Stephen D · Eagle Rock, VABuilt 1947 · S/N 6384 N1965BMsb Aircraft LLC · Statesboro, GABuilt 1948 · S/N 6392 N1967BTurberville Gregory R · Enterprise, ALBuilt 1948 · S/N 6394 N1969BTrayler Jason B · Paragould, ARBuilt 1948 · S/N 6396 N1970BSmith Steven J · Naperville, ILBuilt 1948 · S/N 6397 N1977BSterner Robert E · Kettle Falls, WABuilt 1948 · S/N 6404 N1980BPeterson Roy R · Federal Way, WABuilt 1948 · S/N 6407 N1983BCombs Paul · Gilbert, AZS/N 6410 N1988BKruckeberg Leroy A · Sanford, NCBuilt 1948 · S/N 6415 N2002KDare Michael E · Sherwood, ORBuilt 1946 · S/N 4729 N2010BWestrum Durl Troy · Norwalk, IABuilt 1948 · S/N 6437 N2013BHiggins David R · Ellensburg, WAS/N 6440 N2014BRoot Daniel J · Friday Harbor, WABuilt 1948 · S/N 6441 N2015BAnderson Mark A · Bates City, MOBuilt 1954 · S/N 6442 N2016BHolliday Mark E · Lake Elmo, MNS/N 6443 N2017BStieber Harold J · Brownwood, TXS/N 6444 N2018BShannon Randal S · Drexel, MOBuilt 1948 · S/N 6445 N2019BBrown Nicholas K · Elkin, NCBuilt 1948 · S/N 6446 N2026BLee Robert E · Medford, WIBuilt 1948 · S/N 6453 N2027BHanna Samer · Rmv, CAS/N 6454 N2029AFord Ethan G · Anchorage, AKBuilt 1953 · S/N 4375 N2041BOberholtzer John F · Davis, CAS/N 6468 N2050BHinton Steven J · Chino, CABuilt 1948 · S/N 6477 N2060BSicaras Paul G · Longmont, COBuilt 1946 · S/N 6487 N2064BCrestair Air LLC · Dover, DEBuilt 1948 · S/N 6491 N20657Morgan Leonard D · Greenville, SCBuilt 1938 · S/N 820 N20659Dyer Albert L · New Smyrna Beach, FLBuilt 1938 · S/N 822 N2066KMay-U Airways LLC · Saint Clair Shores, MIBuilt 1947 · S/N 4793 N2068KWomack Wilbur A · Jackson, LABuilt 1947 · S/N 4795 N20690Lunsford William E · Delaware, OKBuilt 1938 · S/N 844 N20692Cleared Direct Inc · Woodlake, CABuilt 1938 · S/N 846 N2071KSale Reported · Hoxie, ARSale reported, canceledBuilt 1947 · S/N 4798 N2073BWestrum D Troy · Norwalk, IABuilt 1948 · S/N 6500 N2076KMuhammad Naseem · Syracuse, NYBuilt 1947 · S/N 4803 N2077BFranklin James R · Henderson, NVBuilt 1948 · S/N 6504 N2080BJohnson Christopher J · Tacoma, WABuilt 1949 · S/N 6507 N2083BOconnor Stephen J · Danbury, CTBuilt 1948 · S/N 6510 N2084KDelisio Matthew W · Lake Elsinore, CAS/N 4811 N2085KSmith Dawson · Halstead, KSS/N 4812 N2086KBolton Derwin B · Jacksonville, TXBuilt 1947 · S/N 4813 N2087BDavies Samuel R · Port Angeles, WABuilt 1948 · S/N 6514 N2090KLang David W · Minot, NDS/N 4817 N2095BCloudbase Assets Limited · Avon Lake, OHS/N 6522 N2105KKeller Joseph P Jr · Wakeman, OHBuilt 1947 · S/N 4832 N2106BCaba Joseph · Covington, LAS/N 6533 N2107BLanoue John Long Sr · Frost, TXBuilt 1948 · S/N 6534 N2128KPayne William C · Duluth, MNBuilt 1947 · S/N 4855 N2132BRamin Jeanette J · Houston, TXBuilt 1949 · S/N 6559

Back to Luscombe 8A