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.

N89681Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282824N8968CDowd John J Jr · Syracuse, KSBuilt 1953 · S/N 18-2978N8968DCleary Katherine E · Mulberry, FLBuilt 1958 · S/N 22-6132N8968JStevens Raymond W · Norfolk, VAS/N 28-2991N8968LAg Aircraft Holdings LLC · Port Saint Lucie, FLBuilt 1974 · S/N AA1B-0418N8968QSonnichsen Landen D · Delta Junction, AKBuilt 2021 · S/N 5802N8968VLittle Gordon D · Watertown, SDS/N 17264324N8968WRc Skywagon LLC · Miami, FLBuilt 1964 · S/N 28-10545N89693Rjw Aviation LLC · Tampa, FLBuilt 1978 · S/N 15282827N8969CStrahl Guenter H · Jackson, NJBuilt 1976 · S/N 28-7690173N8969VCrowley Brett A · Wasilla, AKS/N 17264325N8969WPostage Robert · Chapel Hill, NCBuilt 1964 · S/N 28-10546N8969YTrident Aero Services LLC · Park City, UTBuilt 1971 · S/N 39-132N896ACAri Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881414N896AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2026 · S/N 172S13542N896AKQuadcub Utah LLC · Salt Lake City, UTS/N 1N896ASSilverstein Adam R · Pittstown, NJBuilt 2007 · S/N 82089N896B49 Holdings LLC · Cheyenne, WYBuilt 2021 · S/N MB27N896BCClute William A · Simpsonville, SCBuilt 2011 · S/N 001N896CFMiles Air Leasing LLC · Canonsburg, PABuilt 1968 · S/N 28-4852N896CPCivil Air Patrol · Maxwell Afb, ALS/N 18282394N896DFVenture North Aviation LLC · Cloquet, MNBuilt 2024 · S/N 2881696N896DLLane David A · Yuba City, CABuilt 2006 · S/N 80896N896JUniversity Of North Dakota · Grand Forks, NDBuilt 2022 · S/N 30086N896NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2025 · S/N 4496610N896SCHansen Ernest F · Sequim, WABuilt 2020 · S/N 001N89702Carter Flygare Inc · Sacramento, CABuilt 1978 · S/N 15282830N8970CMcdonald Todd P · Fairbanks, AKBuilt 2001 · S/N 3225MN8970JAll Tech Machine & Tool Inc · Greenwood, ARBuilt 1965 · S/N 28-2993N8970VWinding Creek Aviation LLC · Snellville, GABuilt 1974 · S/N 17264326N8970WYoungblood Wade · Corsicana, TXBuilt 1964 · S/N 28-10548N89718Schad Paul E · Gainesville, TXBuilt 1978 · S/N 15282839N8971DThomas James W · Jay, FLBuilt 1958 · S/N 18-6408N8971JSwearingen Louis S · Summerfield, FLBuilt 1965 · S/N 28-2994N8971MDixon Gary Lynn II · Ooltewah, TNBuilt 1973 · S/N 177RG0371N8971PDerrel Luce Pc · Waco, TXBuilt 1966 · S/N 24-4428N8971VGibson Aviation Services LLC · Hudson, WIBuilt 1974 · S/N 17264327N8971YLaubscher John E · Cazenovia, NYBuilt 1972 · S/N 39-134N89721Propability One LLC · Daytona Beach, FLBuilt 1983 · S/N 17276010N8972CBosn Richard O · Scottsbluff, NEBuilt 1976 · S/N 28-7690174N8972DClarke Timothy B · Howard, SDBuilt 1958 · S/N 18-6411N8972JPascua Jonathan J · Coventry, RIBuilt 1966 · S/N 28-2995N8972VPearce Michael J · Phoenix, AZBuilt 1974 · S/N 17264328N8972WIma Pilot LLC · Sauk Rapids, MNBuilt 1964 · S/N 28-10550N89735N89735 LLC · Stuart, FLBuilt 1978 · S/N 15282847N8973CUrbach Jourdan B · Sherman Oaks, CABuilt 1953 · S/N 22-1557N8973DSnider Scott E DBA · Turner, MTBuilt 1958 · S/N 18-6412N8973FAvelan Enterprises Inc · Elm Grove, LABuilt 1973 · S/N 430195N8973JMuleshoe Flight Club LLC · Muleshoe, TXBuilt 1965 · S/N 28-2996N8973VOcean Flyers LLC · Chatham, NJBuilt 1974 · S/N 17264329
Back to AD 81-18-04 R2