OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,495

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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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.

N9438NSallmon James Henry · Sandpoint, IDBuilt 1981 · S/N 18504356N9439YR C S Drilling Company Inc · West Lake Hills, TXBuilt 1981 · S/N 21064505N943AHHaley Keith · Tonawanda, NYBuilt 1981 · S/N 21064377N943BCrawford Alan R · Buchanan Dam, TXBuilt 1966 · S/N TE-88N943CDStans Homestore Inc · Beatrice, NEBuilt 2005 · S/N 1327N9440QKatz Alan E · Hopkinton, MABuilt 1972 · S/N D-9319N9444MTriple Four Mike LLC · Sand Springs, OKBuilt 1977 · S/N 21062076N9446GStringfellow Regan M · Boerne, TXS/N U20601646N9446NSkywagon LLC · Goochland, VABuilt 1981 · S/N 18504358N9446QGalt Gulch LLC · Ann Arbor, MIBuilt 1972 · S/N TH-236N944DHSouth Delta Aviation Inc · West Helena, ARBuilt 1981 · S/N P21000712N944EBArfvidsson Emil · Mountain View, CABuilt 1997 · S/N 29-0111N944EMHodges Gail A · Fruitland Park, FLS/N 73-30583N944LFAir Northeast LLC · Colorado Springs, COBuilt 1995 · S/N E-2968N944PACrebbs Ben H · Tucson, AZBuilt 1982 · S/N EA-300N944RMKrol Matthew D · Hideaway, TXBuilt 1965 · S/N D-8026N9450SDakota Sierra LLC · Horace, NDBuilt 1966 · S/N D-8045N9451SBurnside Joseph E · Sarasota, FLBuilt 1966 · S/N CE-11N9452GStokes Letta J · Chugiak, AKBuilt 1971 · S/N U20601652N9452MSoares De Matos Guilherme Cesar · Fort Lauderdale, FLBuilt 1970 · S/N 21059352N9452NAlaska Department Of Public Safety · Anchorage, AKBuilt 1981 · S/N 18504359N9455SBlythe Edward A · Dallas, TXBuilt 1966 · S/N D-8050N9456SHerrick Richard J Trustee · Lenox, MABuilt 1966 · S/N D-8036N9457SBishop Raymond E · Darien, ILBuilt 1966 · S/N CE-46N9459MCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1978 · S/N U20604547N945BGDavis James H · Corpus Christi, TXBuilt 1980 · S/N 421C-0870N945CDLunex Power Inc · Tampa, FLBuilt 2005 · S/N 1699N945DTCross Tool & Manufacturing Inc · Flagstaff, AZBuilt 1995 · S/N 29-0046N945RCR&C Aviation Partners LLC · Tucson, AZBuilt 1978 · S/N P21000084N9460SFrosig Jared · Odessa, TXBuilt 1966 · S/N CE-10N9461GMillionair Inc · Ferndale, WAS/N U20601661N9461MMaster Chief Cricket LLC · Morgan City, LABuilt 1970 · S/N 21059361N9461QRose Kim N · East Wenatchee, WABuilt 1972 · S/N D-9322N9461SAndre David A Trustee · Webster Groves, MOBuilt 1966 · S/N D-8053N9461ZMichigan Aeronautics Commission · Lansing, MIBuilt 1981 · S/N U20606505N9462QR & B Corp · Pittstown, NJBuilt 1972 · S/N E-313N9463QCcf Ventures Inc · Bangor, MEBuilt 1972 · S/N D-9324N9464M2morrow Aviation LLC · Abilene, TXBuilt 1977 · S/N 21062079N9465GOsprey Air LLC · Anchorage, AKS/N U20601665N9465QMaydew Aircraft LLC · Dallas, TXBuilt 1972 · S/N D-9325N9465YWof Investments LLC · Dover, DES/N 21064515N9466QLan Dale Co · Reno, NVBuilt 1972 · S/N TH-205N9467QAg Aero Inc · Tallulah, LABuilt 1972 · S/N TH-206N9467SV35 LLC · Portland, ORBuilt 1966 · S/N D-8054N9468QSunrise Aviation Inc · Wrangell, AKBuilt 1972 · S/N E-314N9469CKinetic Concepts LLC · Pensacola, FLS/N 310R1419N9469GGolf Tango Air Racing LLC · Ephrata, WABuilt 1971 · S/N U20601669N946TTTalley Tank Lines Inc · Madera, CABuilt 1992 · S/N TH-1673N9470GDrean Gary T · Rancho Santa Fe, CABuilt 1971 · S/N U20601670N9470MJanes Dwayne O · Edmond, OKBuilt 1970 · S/N 21059370
Back to AD 86-13-04 R3