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.

N9143JN9143j LLC · Fort Wayne, INBuilt 1966 · S/N 28-3197N9143SBooton Charles E · Navarre, FLBuilt 1975 · S/N MC-397N9143VCrazy Mountain Cub LLC · Helena, MTBuilt 1988 · S/N 1809002N9143WLara Anthony Michael Thomas · Manitou Springs, COBuilt 1966 · S/N 28-10764N9144TShiflett Philip B · Marietta, OHBuilt 1985 · S/N 28-8690029N9144VHardin Ralph · New Plymouth, IDBuilt 1969 · S/N 690029N9144WMedema Roger E · Lake Forest, ILBuilt 1966 · S/N 28-10765N9145CReitz Andrew P · Pembroke Pines, FLS/N R18200419N9145JBonertz Brian J · Muscatine, IAS/N 28-3200N9145VRoe Cameron · Salt Lake City, UTBuilt 1969 · S/N 690011N9146DSmith Paul G · Wasilla, AKBuilt 1958 · S/N 18-6536N9146JSwarey Steven · Whiteville, TNBuilt 1966 · S/N 28-3201N9146KBartlett Jesse Charles · Henderson, NVBuilt 1976 · S/N 28-7615178N9146LMalone Aaron E · Wasilla, AKS/N 812-71N9146VWood David Allen · Conyers, GABuilt 1969 · S/N 690025N9146WGam Aviation LLC · Sioux Falls, SDBuilt 1966 · S/N 28-10768N9147THoiles Richard C · Shortsville, NYBuilt 2006 · S/N 632EN9147VN206ht LLC · Pulaski, IABuilt 1969 · S/N 690037N9147WBishop Samuel E · Soquel, CABuilt 1966 · S/N 28-10770N9148GCheutin Didier V · Orlando, FLBuilt 1995 · S/N 24-3362N9148JNovember Nine One Four Eight Juliet LLC · Fulton, MOBuilt 1966 · S/N 28-3203N9148SBlue Skies Aviation LLC · Holland, MIS/N MB-787N9148XFaik Salaheddine · Marion, IABuilt 1988 · S/N 2811019N9149CBryan Robert G · New Lenox, ILBuilt 1978 · S/N R18200422N9149JJones Lynn · Birmingham, ALS/N 28-3204N9149QCovington James A · Huntsville, ALBuilt 1996 · S/N 24-3377N9149SBurnard Russell J · Seward, AKBuilt 2001 · S/N 456RN9149WTcherneshoff Robert · Clayton, NMBuilt 1966 · S/N 28-10775N914ADDepinet Andrew P · Galion, OHBuilt 2026 · S/N 001N914AMWilliamson Tom P · Nacogdoches, TXBuilt 1988 · S/N 2811020N914AZN969az LLC · Miami, FLBuilt 1985 · S/N 17276379N914DSaker Air LLC · Charlotte, NCBuilt 2000 · S/N 1104N914DPGonzalez Ramiro · Lancaster, OHBuilt 1966 · S/N 24-4633N914ETrettin Anthony K · Mason City, IABuilt 2005 · S/N 70599N914GPRoy Dino · Saginaw, TXBuilt 1966 · S/N MA-124N914HMeadows Mark A · Mooresville, INBuilt 1999 · S/N 21325N914HMMiesler Hans U · Penrose, COBuilt 1971 · S/N 1N914HPBonsey James E · Newberg, ORBuilt 1968 · S/N 28-24646N914JBSwartz Eric C Trustee · Aptos, CABuilt 2000 · S/N 18280786N914JDAis Wings LLC · Grand Rapids, MIBuilt 1972 · S/N 17261296N914JWWright John T · Jacksonville, FLBuilt 1975 · S/N 419N914MGHolman Larry E · Cleveland, GABuilt 1970 · S/N 32-1281N914PLand-O-Lakes Flying Club Inc · Bloomfield Hills, MIBuilt 1983 · S/N 28-8311015N914PACoco Aircraft Inc · Merritt Island, FLBuilt 1999 · S/N 2843303N914RLNichols Charles C · Hanford, CABuilt 2004 · S/N 18281399N914RRMartinez Jeff L · Lewistown, MTS/N 17264508N914SCole Thomas Ed · White Settlement, TXS/N 106N914SCHotel Aviation LLC · Oregon City, ORBuilt 2025 · S/N 172S13438N914SWSilver Express Co DBA · Miami, FLBuilt 1999 · S/N 172S8160N914THanley Stuart · Hollywood, FLBuilt 1960 · S/N TD-347
Back to AD 81-18-04 R2