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.

N39BPEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1999 · S/N 2906N39BRSystems Research Corp · Wilmington, DEBuilt 1991 · S/N 122639N39CFFedrigo John A · Moneta, VAS/N 38-79A0765N39CPWhirl'D Helicopters Inc · Sevierville, TNBuilt 2003 · S/N 10069N39CTRotramel Paul D · Hardinsburg, KYBuilt 1968 · S/N 28R-30712N39CWWindham Charles R · Rogersville, TNBuilt 2012 · S/N 91447N39DBKwasinski Mark W · Kalamazoo, MIBuilt 1969 · S/N 153N39DCCruson Dale E · Ontario, ORBuilt 1993 · S/N 20374N39DRLehigh Valley Flying Club Inc · Lehigh Valley, PABuilt 1976 · S/N 28-7790221N39DUYokoo Kureha · Petaluma, CAS/N 22818N39ECSmith Adria A · Kingwood, TXBuilt 1968 · S/N 28-4985N39EJAndersen John · Kenosha, WIBuilt 2006 · S/N 39N39ESHowell Jeff D · Payette, IDBuilt 2010 · S/N 0100N39FZLongley Charles A · Nome, AKBuilt 1962 · S/N 18-7745N39GMonteleone Gene R · Mount Vernon, TXS/N 15N39GCWilliams Jeffrey D · Florence, ALBuilt 1980 · S/N AS123N39GDNovember Sierra Romeo LLC · Byron Center, MIS/N 10250N39GHApaka Lee K · Fairfield, CABuilt 1975 · S/N 65N39GMBacon Gregory A · Prairie Home, MOS/N 0001N39GTAshwill Gregory L Trustee · Overgaard, AZBuilt 2018 · S/N SC-100N39GWKotalite Consultant LLC · West Palm Beach, FLS/N 3096N39HBBartle Henson P · Independence, ORBuilt 2012 · S/N 1N39HUCallaghan Jonathan D · Driggs, IDBuilt 2015 · S/N 3234N39HYReed Hollow Aviation LLC · Franktown, COBuilt 2001 · S/N 2137N39JLLundberg Jonathan S · Fayetteville, TNBuilt 2012 · S/N 1115-2012N39JMJads Aviation LLC · Rowlett, TXBuilt 1960 · S/N 23-1943N39JPCabebe Brian M · Mesa, AZBuilt 1978 · S/N 217N39KWFier William J · Austin, TXBuilt 2000 · S/N 3374N39LDMau Thomas E · Kenmare, NDS/N 18-5757N39LTGeorgia Forestry Commission · Macon, GABuilt 2003 · S/N 924-2003N39MRGraupman Gerald · Chicago, ILBuilt 1969 · S/N EGA-1N39MVMedical Transport Inc · Dover, DES/N 61P07728063385N39NDTerwillegar Charles E · Renton, WABuilt 1967 · S/N R1720082N39NSMacair Inc · Corvallis, ORBuilt 1998 · S/N 2003N39PCN39pc LLC · Portsmouth, NHBuilt 1983 · S/N 18268313N39RFHughes Todd R · Euless, TXBuilt 1996 · S/N 532N39RLAdams Nathan M · Edgewater, FLBuilt 1972 · S/N 416-HN39RSRoberts Terrance M · Fayetteville, ARBuilt 1980 · S/N RS001N39SDMbm Leasing LLC · Jacksonville, NCBuilt 1966 · S/N 28-3565N39SJArrigo Johnathan T · Mill Spring, NCBuilt 1999 · S/N 3269N39SKJustman Robert A · Cotati, CABuilt 2003 · S/N 25726N39TBAlibi Flying Club · Bakersfield, CAS/N 3142N39TSMiller William L · Williamson, GABuilt 1982 · S/N 39N39WBDorstewitz Robert D · Watervliet, MIS/N 1N39WDWilliams Ryan P · Calera, OKBuilt 1984 · S/N 106DN39WYGd Logistics LLC · Circle, MTBuilt 2011 · S/N 3119N39XPMason Samuel · Santa Paula, CABuilt 1976 · S/N K-039N39YBWeaver Brian R · Crossville, TNBuilt 2007 · S/N 91394N3AGoodyear Tire & Rubber Co · Mogadore, OHBuilt 2018 · S/N 008N3AAJones Stephen C · Wadsworth, ILS/N E3B-318
Back to AD 81-18-04 R2