OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,733

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.

N456LLemma Joseph M · Parker, COBuilt 1962 · S/N 28-863N456MDMyres Mark D · Freeland, WABuilt 1996 · S/N 20107N456PAH&H Helicopter LLC · Sauget, ILFirst renewal noticeBuilt 2019 · S/N 1242N456PBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1997 · S/N 400-97N456PCMendelson Mark L · Owego, NYBuilt 2018 · S/N 25787N456PMBerry Michael G · Hot Springs, ARBuilt 1966 · S/N 28-22354N456PPRoberts Calvin D · Bluebell, UTBuilt 2025 · S/N BC-001N456RBSammons Michael A · Lubbock, TXS/N 654N456RHMalik Todd S · Matthews, NCBuilt 1979 · S/N AA5B1252N456RJGraae Michael Horace · Los Angeles, CABuilt 1995 · S/N 21701N456RRAir America Flight Center LLC · Daytona Beach, FLBuilt 1976 · S/N 28R-7635457N456SGGavitt Stephen M · Rensselaer, NYBuilt 2010 · S/N 91307N456SPAc Aviation LLC · Ocklawaha, FLBuilt 1999 · S/N 172S8320N456TGSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2006 · S/N 11136N456THB R S Leasing Inc · Wilmington, DEBuilt 1980 · S/N ME-319N456TWSchmidt Gail M · Florence, COBuilt 2007 · S/N 02-1217N456UHAlba Leasing Services LLC · Scottsdale, AZBuilt 2014 · S/N 4655N456WMWright Alfred M · Toney, ALBuilt 2001 · S/N 001N456YDodson International Parts Inc · Rantoul, KSBuilt 2000 · S/N 2843353N456ZRedpole2 LLC · Kalispell, MTBuilt 2023 · S/N 1332N4570MMatthews Richard W · Kasilof, AKBuilt 2018 · S/N 040750N4570TWinslow Dean L · Stanford, CABuilt 1972 · S/N 28-7210013N4570WGuffey Jerry D · Lebanon, TNS/N 13060N4571TVandeventer Matthew S · Dillingham, AKS/N 32-7200023N4571WBernard Scott Sr · Denham Springs, LAS/N 13061N4571XFly Boys Aviation LLC · Tecumseh, MIS/N 28-7690039N4571YDavis James J · Beaver Dam, WIBuilt 1967 · S/N 25-4235N4572WKelton Joel B · May, TXBuilt 1976 · S/N 13062N4573White James Jr · Glen Allen, VAS/N 101N4573JRoss James A · Barrington, RIS/N 28R-30438N4573RKaufmann Carl S · Springfield, MABuilt 1965 · S/N 28-21314N4573ZMatty Elizabeth · Tucson, AZS/N 22-8082N4574JWakefield Aircraft LLC · Cooperstown, NDBuilt 1968 · S/N 28R-30439N4574RKing Vincent A · Grand Junction, COBuilt 1965 · S/N 28-21316N4574TBas Part Sales LLC · Greeley, COBuilt 1972 · S/N 34-7250137N4575FSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1976 · S/N 28-7715049N4575PWings Management Co LLC · Rio Rancho, NMBuilt 1960 · S/N 27-84N4575WN4575w LLC · Santa Fe Springs, CABuilt 1976 · S/N 13065N4575XPar Mar Bluffs LLC · Parker, SDS/N 28-7690034N4576FDakota Aviation LLC · Sioux Falls, SDBuilt 1976 · S/N 28-7715050N4576XElon Aviation LLC · Burlington, NCBuilt 1975 · S/N 28R-7635081N4576ZBauman Solomon A · Lyle, WAS/N 22-8085N4577Gateway Of Sturgis LLC · Sturgis, MIBuilt 1999 · S/N 172S8285N4577XFairhaven LLC · Meridian, MSBuilt 1975 · S/N 32-7600004N4578TMeditz Robert S · Chalfont, PABuilt 1972 · S/N 28R-7235097N4578WAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 13068N4579Kinney Joseph B · Palmer, AKBuilt 2023 · S/N 01946N4579JSnagwood Corp · Brentwood, CABuilt 2012 · S/N 5819N4579RSmelser Brady W · Glendive, MTBuilt 1965 · S/N 28-21321N4579TNavajo Air LLC · Scottsdale, AZBuilt 1972 · S/N 28R-7235098
Back to AD 81-18-04 R2