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.

N8008EPegasus Aviation LLC · Wichita, KSBuilt 2014 · S/N TH-2428N8008KKraus Lee G Jr · Port Orange, FLBuilt 1990 · S/N E-2559N80093Kubecka Daniel P · Edna, TXBuilt 1976 · S/N 18503091N8009RDyczek Albert J · Omaha, NEBuilt 1969 · S/N D-8976N800BAN8vv Inc · Corpus Christi, TXBuilt 1981 · S/N 414A0667N800CFSparky'S Air LLC · Wilmington, DEBuilt 1990 · S/N TH-1599N800CXColeman James M · Aiken, SCBuilt 1979 · S/N E-1435N800DD2826 LLC · Inola, OKBuilt 1995 · S/N 29-0024N800DFFox Aircraft LLC · Bethel, AKBuilt 1980 · S/N 20700621N800EEMarks Robin · San Luis Obispo, CABuilt 1979 · S/N D-10288N800FSNorads Aerial Services LLC · Leesburg, VAS/N 401A0119N800FUKing Air 3 Au LLC · Ozark, MOBuilt 1978 · S/N 21062792N800JCThomas Bonner Enterprises LLC · Lubbock, TXBuilt 1979 · S/N TK-90N800KWVenture Air Solutions Inc · Opa Locka, FLBuilt 1976 · S/N 402B1063N800LC54 Aero LLC · Spade, TXBuilt 1968 · S/N 18258879N800MRRoney John F · Mission Hills, KSBuilt 1964 · S/N D7624N800NLNewhalen Lodge Inc · Anchorage, AKBuilt 1979 · S/N U20604860N800SMTofanzadeh Abdolreza · Chula Vista, CABuilt 1972 · S/N 421B-0275N800WBBestgen Walter E II · Deltona, FLBuilt 1981 · S/N 18504262N8010ZRosander Mining Co Inc · Mc Grath, AKBuilt 1965 · S/N U206-0410N8011RChristl Steven J · Shady Shores, TXBuilt 1969 · S/N D-8979N8011ZJackson Jet Center · Boise, IDS/N U206-0411N80124Amundsen John D · Soldotna, AKS/N 18503094N8015ZKennedy Kerry D · Anchorage, AKBuilt 1965 · S/N U206-0415N8018VLight Flight Ltd · Lehighton, PABuilt 1967 · S/N 188-0268N8019ZGolden Eagle Outfitters Inc · Delta Junction, AKBuilt 1965 · S/N U206-0419N801DCMalibu Queen LLC · Portola Valley, CABuilt 1987 · S/N 46-08053N801TMajestic Enterprises Ltd · Wilmington, DEBuilt 1973 · S/N TH-330N8021AEncompass Partners · Goodwell, OKBuilt 1990 · S/N CE-1520N80229Fischer Alfred M DBA · Genoa City, WIS/N 18503105N80256Dew Farms Inc · Ulysses, KSS/N 18503109N8026TRdz Aircraft LLC · Effingham, ILBuilt 1992 · S/N E-2701N8028DHammond Mick L · Abilene, TXBuilt 1991 · S/N CE-1550N8028JVintage Aircraft Sales LLC · Radnor, OHBuilt 1990 · S/N CE-1531N802BTCasavia Corp · Guelph OntarioBuilt 1998 · S/N LIV-080N802CDTs Flight LLC · Saint Louis Park, MNBuilt 2001 · S/N 0103N802MCRunaway Plane LLC · Oklahoma City, OKBuilt 1980 · S/N 335-0044N802MSMarotta Scientific Controls Inc · Montville, NJBuilt 1983 · S/N 21064780N802NHWiechmann August J · Hubbard, IABuilt 1992 · S/N E-2694N802NXLacey David G · Locust Grove, GABuilt 2004 · S/N 1222N8032XCass Joseph R · Nevis, MNBuilt 1991 · S/N CE-1551N80337Registered aircraftBuilt 1976 · S/N 18503114N8033HArde Wayne A · Simla, COBuilt 2003 · S/N 0644N80359Hartman Brian D · Anchorage, AKBuilt 1976 · S/N 18503116N8036TPaysse John G · Hanford, CABuilt 1980 · S/N EA-150N8038ZBas Part Sales LLC · Greeley, COBuilt 1990 · S/N E-2568N80391Croney Abram C · West Jordan, UTBuilt 1976 · S/N 18503117N803DLRapids Ruddervators LLC · Wisconsin Rapids, WIBuilt 1973 · S/N D-9448N8043BT & A Aviation 2 LLC · Saint Petersburg, FLBuilt 1991 · S/N E-2618N80449Davis Lawrence J Jr · Wasilla, AKS/N 18503119
Back to AD 86-13-04 R3