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.

N1463KAasness Todd D · Fresno, CABuilt 1946 · S/N 4190 N1471KBarnes Sammy Dean · Taylorsville, NCBuilt 1946 · S/N 4198 N1477KRegistration Pending · Hamilton, TXRegistration pendingBuilt 1946 · S/N 4204 N1486KKruckeberg Leroy A · Sanford, NCBuilt 1946 · S/N 4213 N1490KBell Gary W · Jones, OKFirst renewal noticeS/N 4217 N1528BShelby Aero Club LLC · Shelbyville, INBuilt 1948 · S/N 6155 N1531KMckinney Timothy Scott · Guthrie, OKS/N 4258 N1534KShannon Randal S · Drexel, MOBuilt 1946 · S/N 4261 N1535KKeenan Cheryl L · Saratoga, CABuilt 1946 · S/N 4262 N1537KSwart Wayne C · Rescue, CABuilt 1946 · S/N 4264 N1538BShiffer Lyle J · Waterford, MIBuilt 1981 · S/N 6165 N1540BTiberg Robert E · Sparta, TNBuilt 1948 · S/N 6167 N1541BLaux Christopher B · Gladstone, MOBuilt 1955 · S/N 6168 N1544KMcmillan Gary L · Rockwall, TXBuilt 1946 · S/N 4271 N1550KJerale Lance F · Manitowoc, WIBuilt 1946 · S/N 4277 N1555KPerdue Adrian V · Denton, NCBuilt 1946 · S/N 4282 N1556KHilton Gregory Lee · Dallas, GABuilt 1946 · S/N 4283 N1560KHayward Jeffrey L · Thomasville, GABuilt 1946 · S/N 4287 N1562KClark Stephen R · Sonoma, CABuilt 1946 · S/N 4289 N1564KMenzies Joan K · Menard, TXS/N 4291 N1565KKonechne Patrick F · Chamberlain, SDBuilt 1946 · S/N 4292 N1571KDunham Roger S · Athol, IDBuilt 1946 · S/N 4298 N1579KDematteo Scott R · Arroyo Grande, CABuilt 1946 · S/N 4306 N1582KKegley Robert E · Naples, FLS/N 4309 N1586KSilkworth Michael · Willoughby, OHS/N 4313 N1590KAntique Aircraft And Automobile LLC · Van Alstyne, TXBuilt 1946 · S/N 4317 N1591KGreenheck Austin J · Minot, NDS/N 4318 N1608KHultberg Randy S · Newport News, VABuilt 1946 · S/N 4335 N1609KHoot Brian D · Toldeo, OHBuilt 1946 · S/N 4336 N1611KEverhart Benjamin F Jr · Winston Salem, NCBuilt 1946 · S/N 4338 N1616KSeiter Randy R · Lake Isabella, MIBuilt 1946 · S/N 4343 N1618KHoffman Christopher P S · Elizabethtown, PABuilt 1955 · S/N 4337 N1625KDalzell Dean M · Donnelly, IDBuilt 1946 · S/N 4352 N1635KPellegrino Richard · Honolulu, HIBuilt 1946 · S/N 4362 N1641LRasch Kevin W · Denton, TXS/N 4368 N1658KFischer James H · Wisconsin Rapids, WIBuilt 1946 · S/N 4385 N1693KOlson Russell O · Eureka Springs, ARS/N 4420 N1694KKorman Nicholas · Lebanon, INBuilt 1947 · S/N 4421 N16CYSanchez Joseph I · Jonesville, KYBuilt 1946 · S/N 3204 N1707KWard Lional Ray · Varnville, SCBuilt 1947 · S/N 4434 N1833BMills Walter H Jr · Milford, OHBuilt 1948 · S/N 6260 N1850BEbert Richard D · Owosso, MIBuilt 1948 · S/N 6277 N1907BCurrie Mark H · Justin, TXS/N 6334 N1910BMckenna Kent T · Torrance, CABuilt 1948 · S/N 6337 N1911BJacobson Richard T · Overton, NVBuilt 1948 · S/N 6338 N1921KSmeltzer Paul C · Texarkana, ARBuilt 1941 · S/N 1801 N1936BSmith Jeffrey C · Asheboro, NCBuilt 1948 · S/N 6363 N1939Hinckley Steven F · Colorado Springs, COBuilt 1939 · S/N 1094 N1942BFarkas Edward J · Iowa City, IAS/N 6369 N1946KRamin Jeanette J · Houston, TXBuilt 1947 · S/N 4673

Back to Luscombe 8A