Skip to content

Registered aircraft · 40,471

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  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, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
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.

N8119CHenry Gary A · Narragansett, RIBuilt 1979 · S/N 28-8016126 N8119EMorse Daniel D · Edinburg, TXFirst renewal noticeBuilt 1959 · S/N 1390 N8119HPiper Warrior LLC · Middleton, MABuilt 1979 · S/N 28-8016127 N8119PStelling William F · Fairbury, NEBuilt 1979 · S/N 28-8016128 N8119QBay Lux Ventures LLC · Tampa, FLBuilt 1979 · S/N 28-8016129 N811AJScarrow Justin · Palmer, AKS/N 18-8457 N811ASS&A Flying LLC · Minden, NEBuilt 1978 · S/N 28-7890306 N811BJSix Pack Aviation LLC · Pocono Pines, PABuilt 1979 · S/N 17272287 N811DHRegistered aircraftBuilt 1993 · S/N 320 N811DWPerucca Douglas E · Wasilla, AKBuilt 1961 · S/N 18-7582 N811EBBanks Cecil E Jr · Dayton, NVBuilt 2017 · S/N 72811 N811HATate Grady · Harrisburg, NCS/N 17700181 N811JDSanders Jason C · Babylon, NYBuilt 1975 · S/N 17265353 N811RFMapes Neal E · Prineville, ORS/N 22069 N811RVMorgan Matthew P · Gainesville, GAFirst renewal noticeBuilt 1991 · S/N 1 N811WCampbell Larry L · Fort Mill, SCBuilt 1979 · S/N 492 N811YDRiser Aviation LLC · Foley, ALBuilt 2004 · S/N 2278 N81202Pray Aviation Inc · Augusta, KSBuilt 1979 · S/N 28-8016144 N8120BGreat Northern Aircraft Inc · Griffith, INBuilt 1979 · S/N 28-8016134 N8120FPray Aviation Inc · Augusta, KSBuilt 1979 · S/N 28-8016136 N8120JCope Christopher J · Plumas Lake, CABuilt 1979 · S/N 28-8016140 N8120MMckissick John R · Westminster, MDBuilt 1979 · S/N 28-8016141 N8120XMccool Kenneth Wade · Olive Branch, MSBuilt 1979 · S/N 28-8016142 N8121FKraack Stephen T · Lithia, FLBuilt 1979 · S/N 28-8016145 N8121JSchluckebier Daniel C · Aldie, VABuilt 1979 · S/N 28-8090141 N8121KRegistered aircraftBuilt 1979 · S/N 28-8090142 N81227Grumman Aviation LLC · Virginia Beach, VABuilt 1977 · S/N AA5B0460 N8122BErwin Mark N · Snyder, TXBuilt 1979 · S/N 28-8090149 N8122CJordan Walter B · Chehalis, WABuilt 1954 · S/N 22-2268 N8122HSchlesinger Richard J · West Cornwall, CTBuilt 1979 · S/N 28-8090151 N8122QN8122q LLC · Venice, FLBuilt 1979 · S/N 28-8090152 N8122WRoberts Barry R · Aurora, COBuilt 1965 · S/N 28-2229 N81237Registration Pending · Austin, TXRegistration pendingS/N AA5B0462 N81250Sanchez Paul K · Boca Raton, FLFirst renewal noticeBuilt 1979 · S/N 28-8016147 N81251Winfield John F Jr · Scituate, RIBuilt 1977 · S/N AA5B0473 N81259Thermodynamic Sciences LLC · Irvington, ALS/N 2034 N8125LHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1979 · S/N 44-8095010 N8125WLynch Ronald · Carson City, NVBuilt 1965 · S/N 28-2233 N8125YGlass Jody L · Indianapolis, INBuilt 1979 · S/N 28-8016146 N81260Trusty Archer LLC · Ann Arbor, MIBuilt 1979 · S/N 28-8090155 N8126DHackleman Brian K · Rochester, NYS/N 22-5617 N8126EAnderson Wilbur W Trustee · Lead Hill, ARBuilt 1978 · S/N 17272143 N8126MWest Hawaii Wingers Incorporated · Kailua Kona, HIBuilt 1979 · S/N 28-8016149 N8126XB2fh Ltd · Allentown, NJBuilt 1979 · S/N 28-8090154 N81274Elhaje Tamim · Cypress, TXBuilt 1977 · S/N AA5B0482 N8127DTrimmer Marvin E · Willow, AKBuilt 1957 · S/N 22-5618 N8127EFugate Ruth · Riverside, CARegistration revokedBuilt 1959 · S/N 1398 N8128DBuckner John L · Ragland, ALBuilt 1957 · S/N 22-5619 N8128WSilver Wings Legacy LLC · Weatherford, TXBuilt 1965 · S/N 28-2238 N8128XSimmons Kenton L · Van Alstyne, TXBuilt 1979 · S/N 28-8016153

Back to AD 80-04-03 R2