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.

N47CDRs Aviation Services · Moorpark, CABuilt 2008 · S/N 4350N47CTSweetwater Flyers LLC · Emporia, KSBuilt 1972 · S/N 17701769N47CWPetersen Alfred Charles · Buffalo Grove, ILBuilt 1986 · S/N 840N47DCL&D Joint Sealing LLC · Fairbury, NEBuilt 1985 · S/N 3515N47DERichards Ronald W · Grant City, MOBuilt 1996 · S/N 23106N47DHBeard Donald Ray · Bulverde, TXBuilt 1983 · S/N 129N47DLFairley Michael L · Shawnee, KSS/N 608-320-354N47ECRv Aviation LLC · Wilmington, DEBuilt 2009 · S/N 5130N47EEGt Aviation Solutions LLC · Mount Juliet, TNS/N 27-2009N47EYWof Investments LLC · Dover, DES/N 2359N47EZRinell Eric S · San Luis Obispo, CABuilt 2020 · S/N 0002N47FL3429 Capital Holdings LLC · Jupiter, FLBuilt 2024 · S/N 3429N47FSDahl Duane A · Glasgow, MTS/N 11-102N47GFGlobal Flight Support And Sales Inc · Tampa, FLBuilt 1997 · S/N 17280161N47HJWhite Billy C · Baker, FLBuilt 1987 · S/N 476N47HYJoseph C Thomas · Lenoir, NCBuilt 2000 · S/N 2054N47JEHurley Nicholas John · Trinity, NCBuilt 1977 · S/N 32R-7780532N47JGCorcoran Peter A · Fallbrook, CABuilt 1976 · S/N 47N47JKKerr Jerry T · Mount Vernon, WABuilt 1996 · S/N J1GF-1108N47JLElliott David Robert · San Jose, CABuilt 1996 · S/N 3923N47JPBigger Val J · Las Cruces, NMBuilt 2003 · S/N 1900N47JQJaquish William E · Tunkhannock, PABuilt 2003 · S/N 2109N47LMelugin Michael R · Manteo, NCBuilt 1977 · S/N 0770N47LHPompano Senior Squadron Flying Club Inc · Pompano Beach, FLBuilt 1979 · S/N 28-7990480N47LULetourneau University · Longview, TXBuilt 2017 · S/N 4496416N47MEN47me LLC · Tampa, FLBuilt 1981 · S/N 6008848161250N47MKAztec Aviation Two LLC · Augusta, GABuilt 1973 · S/N 27-7305122N47MLWitt Jerry D III · Houston, TXBuilt 1956 · S/N 22-3865N47NLAnton Billy V · Satanta, KSBuilt 2018 · S/N 135BN47NZFish Dwain E · Silver Springs, NVS/N 1947N47PGRandall Skye Sanjay · Lansdowne, PABuilt 1977 · S/N AA5A0340N47PLGreer Wesley E · Woodstock, GABuilt 2008 · S/N 72157N47RGGossard Philip G · Stonington, MEBuilt 1994 · S/N 3290N47RHWilson Alexander M · Inyokern, CAS/N 177RG0185N47SSandlapper Aviation Of De Inc · Bennington, VTBuilt 1970 · S/N 28R-35769N47SDWampler William C · Canton, TXS/N 108-0989N47STFuhs Nicholas J · Advance, NCS/N 2739N47TDBeene Donald · Westfield, INBuilt 1999 · S/N 60023N47TNFlight Operations Aircraft LLC · Wilmington, DEBuilt 2005 · S/N 172S9996N47TSStewart Terry · Anchorage, AKBuilt 1977 · S/N 18-7709120N47TWRiley Steven M · Bucyrus, KSBuilt 2026 · S/N 0005611N47UAleco 182 LLC · Vestavia Hills, ALBuilt 1980 · S/N R18201525N47VMCox Michael · Casper, WYBuilt 2023 · S/N 634-2023N47WCFly Girls Aviation LLC · Saint Amant, LABuilt 1959 · S/N TD-241N47WLSchettler Patrick J · Garnett, KSBuilt 2001 · S/N MM001N47XXEagle Air LLC · Boulder, COBuilt 1977 · S/N 30N47ZRZira 2x Alw LLC · College Place, WAFirst renewal noticeBuilt 1968 · S/N 28-4974N48007White Andrew Kyle · San Diego, CABuilt 2003 · S/N 5497-01N4800LFlying Aces LLC · Scappoose, ORBuilt 1967 · S/N 28-4139N4800MDunn Bernard P · Carson City, NVBuilt 1980 · S/N 15284484
Back to AD 81-18-04 R2