OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,728

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
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:81-18-04-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:81-18-04-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.

N31445Kuther Kenneth J · Nezperce, IDS/N 2176N31449Peterman Keith A · Taylorsville, KYBuilt 1978 · S/N 2178N3144PEurohaus LLC · Phoenix, AZBuilt 1957 · S/N 23-1075N3144TKinsfather John D · Fowler, CABuilt 1967 · S/N 17700444N3144VMike Smith Aviation International Inc · Napa, CABuilt 2002 · S/N 172S9123N3144ZWasilowski Richard P · Arlington, WABuilt 1959 · S/N 22-7089N31453Kuhlig Clemens C · Hobe Sound, FLBuilt 1979 · S/N 2189N31456Flying Time LLC · Jenks, OKBuilt 1979 · S/N 2190N3145MWright Jeffrey Crandel · Opelika, ALBuilt 1992 · S/N L001N31465Stewarts Aircraft Service Inc · Waynesville, OHBuilt 1979 · S/N 2198N3146LGarnett Robert A · Drewsey, ORBuilt 1992 · S/N 595N3146SBell Stephen Francis Trustee · Ponte Vedra, FLBuilt 2005 · S/N 40047N31474Nemeroff Jason R · Scappoose, ORBuilt 1979 · S/N 2205N31475Southern Aircraft Consultancy Inc Trustee · Casper, WYS/N 2207N3147TClinton Grant A · Portage Des Sioux, MOS/N 17700447N3147ZNeudorf Robert H · Alamogordo, NMBuilt 1959 · S/N 22-7094N31482First Flight Aero LLC · Reno, NVBuilt 1980 · S/N 2218N31485Unusual Attitudes LLC · Bates City, MOBuilt 2006 · S/N 4088N3148MThoft Matthew M · Wasilla, AKBuilt 1947 · S/N 12-1835N3148TMiller John W · Bluffton, INBuilt 1967 · S/N 17700448N3149QClear Air LLC · Ashford, CTBuilt 1977 · S/N 28-7790439N3149TShugart Fredrick William · Canfield, OHBuilt 1967 · S/N 17700449N314AKTremble Toby K · Wasilla, AKBuilt 2024 · S/N 1001N314AVN1412v LLC · Manassas, VABuilt 1974 · S/N 17263557N314DBButler David Trustee · Palos Park, ILBuilt 2004 · S/N 921N314EPHeadings Andrew R · Blue River, WIBuilt 1998 · S/N 24378N314FRHawkeye Helicopter LLC · Lyndon, KSBuilt 1998 · S/N 18280260N314GTYellow Jacket Flying Club Inc · Atlanta, GABuilt 1981 · S/N 17274774N314JLawrence B Botsford · Sanger, TXBuilt 2008 · S/N 3035N314JASharp Jerry L · Georgetown, TXBuilt 1984 · S/N 828N314JBBratton Johnny B · Williamsport, TNBuilt 1999 · S/N 2843226N314KBMatthews Grover C · Hardinsburg, KYBuilt 1958 · S/N 23-1391N314LARaintree Aviation LLC · Mesa, AZBuilt 2013 · S/N 172S11285N314LFEnalas Corp · Bayonne, NJBuilt 2004 · S/N 20-1027N314MAircraft Partner Holdings Inc Trustee · BerlinBuilt 2010 · S/N 524-2010N314MFGobel Victor M · White City, ORBuilt 2023 · S/N JA5980920N314MZZemsta Mike · New Britain, CTBuilt 2019 · S/N 90454N314PTStrong Thomas W · Rigby, IDBuilt 2006 · S/N 90489N314PWJ&S Corley LLC · Peoria, AZBuilt 2000 · S/N 2844031N314REvans Randall B Trustee · Fallon, NVBuilt 1998 · S/N 399-98N314RARochester Air Center LLC · Canandaigua, NYBuilt 1998 · S/N 17280489N314RSAcorn Mutual Flying Club Inc · Hershey, PABuilt 1977 · S/N 17269038N314RVRegistered aircraftBuilt 2007 · S/N 802N314SAAeryn Innovations LLC · Dallas, TXBuilt 2003 · S/N 18281243N314SEZaludek Joseph S · Eugene, ORBuilt 2003 · S/N 40.328N314SHGrover Arlan K · Aurora, COBuilt 1999 · S/N 114N314SRRoesler Scott D · Homer, AKBuilt 1989 · S/N 314N314SYDeas James A · Independence, ORBuilt 2013 · S/N 72973N314TRShalexco LLC · Salt Lake City, UTBuilt 1979 · S/N R18201086N314TSSteele William G · Warrenton, VABuilt 2003 · S/N 80877
Back to AD 81-18-04 R2