Skip to content

Registered aircraft · 40,394

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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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.

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 N8129FHigh Exposure Inc · Wilmington, DEBuilt 1966 · S/N 15064229 N8129JFunk Wendell L · Lancaster, PABuilt 1982 · S/N 28-8290093 N812ATHaverlah Dennis W · Cedar Park, TXS/N 28-7716211 N812BBAlexander Matthew J · Cumming, GAS/N 22172

Back to AD 79-10-03 R2