OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,497

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.

N335NMarple Scott D · Indianapolis, INBuilt 1964 · S/N D-7752N335PElvin Robert Brian · Grove, OKBuilt 1996 · S/N E-3005N335PCOcow LLC · Jenks, OKBuilt 1980 · S/N 335-0053N335PGSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2005 · S/N 1504N335PW335 Leasing LLC · Englewood, COS/N 335-0011N335RAirdocs LLC · Atlanta, GABuilt 2000 · S/N E-3335N335SFRamont Ronald G Jr Trustee · Modesto, CABuilt 1977 · S/N 21062413N335SMMf Property Management LLC · Hattiesburg, MSBuilt 1979 · S/N 3350020N335TBJkh Enterprises LLC · Westfield, INBuilt 1987 · S/N CE1166N335TCSchnell Daniel · Sisters, ORBuilt 1966 · S/N D-8274N335TJYork Michael · Reston, VABuilt 1979 · S/N 335-0012N335VHolden Donald T · Cherokee, IABuilt 1980 · S/N D-10338N3360RRoschi Nancy L · Stevensville, MTBuilt 1975 · S/N 18502874N3360SMohler Earl C · Bonita, CAS/N 21059160N3363YCamlik Air LLC · Wausau, WIBuilt 1978 · S/N 21063145N3364AVan Heel Tyler R · Newberg, ORBuilt 1969 · S/N CE-287N3364BDilley Darrel L · La Salle, COBuilt 1977 · S/N CE-734N3364SAir Deeken Ltd · Doylestown, OHBuilt 1969 · S/N 21059164N3365SWinger Cattle Co Inc · Johnson, KSBuilt 1969 · S/N 21059165N3366ST R Webster And Son Inc · Rexburg, IDBuilt 1969 · S/N 21059166N3367Klaasmeyer Construction Co · Conway, ARBuilt 1966 · S/N TE-146N3367RRegistered aircraftS/N 18502875N3367SSierra Co Llp · Wendell, IDBuilt 1973 · S/N 18502280N3368SForbes Amanda M · Huachuca City, AZBuilt 1969 · S/N 21059168N3369SC-210 Lc · Atlantic, IABuilt 1969 · S/N 21059169N336APJsb Investments LLC · Morristown, TNBuilt 2012 · S/N E-3977N336CABergeron Machine Shop Inc · Abbeville, LABuilt 1998 · S/N EA613N336CBBeechair LLC · Helena, MTBuilt 2002 · S/N E-3431N336HPChs Acquisitions Inc · Dallas, TXBuilt 1989 · S/N CE1312N336LMKlm Unlimited Inc · Staples, MNS/N E-1587N336MTNorth Peak Aviation LLC · Waunakee, WIBuilt 1999 · S/N E-3265N336NANickravesh Niknam J · Saratoga, CABuilt 1980 · S/N E-480N336PWCajan LLC · Kings Mountain, NCBuilt 1982 · S/N EA-297N336RDByone Steve · Natchitoches, LABuilt 1996 · S/N E-3008N336RWBe5816 LLC · Simi Valley, CABuilt 2005 · S/N E-3636N336SQla Air LLC · Fort Myers, FLBuilt 2013 · S/N E-3989N336TTophatter85 LLC · Kirksville, MOBuilt 1978 · S/N E-1219N3370SWittenborn Grant A · Olathe, KSBuilt 1973 · S/N 18502281N3371LAgresti Harold David · Ceres, CABuilt 1967 · S/N 185-1323N3372SBmf Services USA LLC · Satellite Beach, FLBuilt 1969 · S/N 21059172N3373LHowell Nicholas A · Englewood, COBuilt 1967 · S/N 185-1325N3374LLewallen William J · Eloy, AZBuilt 1967 · S/N 185-1326N3374SCcf Ventures Inc · Bangor, MEBuilt 1969 · S/N 21059174N3375LRowan William · New Fairfield, CTBuilt 1967 · S/N 185-1327N3376GLindsay Aviation Inc · West Seneca, NYBuilt 1976 · S/N 310R0818N337ARRegistration Pending · Medford, ORRegistration pendingBuilt 1955 · S/N G-269N337CHAviation Specialty Services LLC · Beaufort, NCBuilt 1977 · S/N 33701836N337DMMcwhorter Michael S · Fortuna, CABuilt 1968 · S/N P206-0471N337EEAmpaire Inc · Long Beach, CABuilt 1974 · S/N 33701600N337PCPhantom Technologies LLC · Garden City, IDBuilt 1980 · S/N 21064212
Back to AD 86-13-04 R3