Skip to content

Registered aircraft · 119

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 ('8190114')
  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 ('8190114')
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.

N1947BArcher Matthew C · Beaufort, SCBuilt 1948 · S/N 6374 N2000BRogers Terrence William · Almond, WIBuilt 1948 · S/N 6427 N2004KCalhoun Jerry H · Washington, NCBuilt 1946 · S/N 4731 N2007BVan Linder Richard A · Scotts, MIBuilt 1948 · S/N 6434 N2017KMorris Shane E · Pewaukee, WIBuilt 1947 · S/N 4744 N2032BAyers Ryan · Santa Maria, CAS/N 6459 N2037BSilvaire LLC · White Riv Jct, VTBuilt 1948 · S/N 6464 N2045BHearst Jeffrey A · Saint Louis, MOBuilt 1948 · S/N 6472 N2050KWalton T Michael · Hudson Falls, NYBuilt 1947 · S/N 4777 N2054BMudry Ryan N · Del Rio, TXBuilt 1949 · S/N 6481 N2081BLepkowski Daniel P · Industry, PABuilt 1948 · S/N 6508 N2089BHales Janell W · Richland, WABuilt 1948 · S/N 6516 N2097BZubor Robert L Jr · Trevor, WIBuilt 1948 · S/N 6524 N2109BSchilling Aviation LLC · Britton, MIBuilt 1948 · S/N 6536 N2126BSkychair LLC · Alexandria, VABuilt 1949 · S/N 6553 N2129BValdez Marcos A · Fort Worth, TXS/N 6556 N2145BHorning Richard H · Galion, OHBuilt 1949 · S/N 6572 N2163BMontgomery Douglas R · Fairbanks, AKBuilt 1949 · S/N 6590 N2178BSouthern Utah University · Cedar City, UTBuilt 1949 · S/N 6605 N2183BPhillips William L · Easthampton, MABuilt 1949 · S/N 6610 N2210BWright Duane C · Sanford, FLBuilt 1949 · S/N 6637 N2212BAnderson Mark A · Bates City, MOS/N 6639 N2219BPuls Kurt V · Valparaiso, INBuilt 1949 · S/N 6646 N2225BGrove Robert L · Boerne, TXBuilt 1949 · S/N 6652 N2245BTardiff Richard A Trustee · Kealakekua, HIBuilt 1949 · S/N 6672 N2269KDelaney John T III · Bangor, PABuilt 1947 · S/N 4996 N2313KPitcher Benjamin A · Fishers, INBuilt 1948 · S/N 6373 N2346BHokanson Elijah R · Ashby, MNS/N 6473 N2405KLockwood Quinton J · Hillsdale, MIBuilt 1947 · S/N 5132 N26324Eigsti Rodney · Friend, NEBuilt 1949 · S/N 6728 N2645Durrett Aviation · Anchorage, AKS/N 6282 N2746KMiller Rondo T · Coon Rapids, MNBuilt 1947 · S/N 5473 N2795KIvy James III · Seligman, AZBuilt 1947 · S/N 5522 N34NWWarner Norris E · Pipe Creek, TXS/N 6756 N3527GMcbee Joseph L · Atlanta, KSBuilt 1959 · S/N S-55 N3528GBorg Michael A · Aptos, CAS/N S-56 N3542GBibb Henry Q Jr · Durham, NCBuilt 1959 · S/N S-74 N3545GObrien A Scott · Santa Rosa Valley, CABuilt 1960 · S/N S-77 N3548GWild Animal Sanctuary · Keenesburg, COBuilt 1960 · S/N S-80 N36FBCertified Aeronautical Products LLC · Moody, TXBuilt 1948 · S/N 6474 N527EDDorr Eric J · Piseco, NYBuilt 1949 · S/N 6555 N6517BBarnes Sammy D · Taylorsville, NCS/N 4715 N71311Lady Luscombe LLC · Seattle, WABuilt 1946 · S/N 2738 N72076Hughes Glenn D · Wrightsville Beach, NCBuilt 1946 · S/N 3503 N801BLiem Daniel L · Brea, CABuilt 1950 · S/N 6731 N803BBores Scott J · Huron, OHS/N 6733 N804PBFrazier Brian D · Jackson, MSBuilt 1950 · S/N 6734 N805BMast Henry V · Dayton, TXBuilt 1950 · S/N 6735 N806BBuoni Darin P · Bakersfield, CAS/N 6736 N809BSecker Timothy A · Olympia, WABuilt 1950 · S/N 6739

Back to Luscombe 8F