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.

N21MTTarrant County College · Fort Worth, TXBuilt 1967 · S/N 320F-0017N21NPRossi Michael · Ronan, MTBuilt 1978 · S/N TK-77N21RGMacair Aviation LLC · Xenia, OHBuilt 1969 · S/N 20700066N21RW1rw LLC · Mont Vernon, NHBuilt 1967 · S/N TE-360N21SGTwo One Sierra Golf LLC · Seattle, WABuilt 1976 · S/N 421C0039N21SHFlight Less LLC · Helena, MTBuilt 1986 · S/N D-8423N21SSMidwest Corporate Air Inc · Bellefontaine, OHBuilt 1978 · S/N 421C0473N21VRJb Aviation LLC · Baton Rouge, LABuilt 1989 · S/N E-2468N21WPAir Dryden LLC · Dothan, ALBuilt 1972 · S/N E-336N21WUDallas Aero & Sales LLC · Poplar, MTBuilt 1979 · S/N 421C0650N21XCHeaton Joshua · Allen, TXBuilt 2000 · S/N 40007N21YYShep Air Inc · Cedar Rapids, IABuilt 2005 · S/N 1664N220Atlantic Coast Aviation Inc · Dover, DEBuilt 2002 · S/N 0177N2201LHorizon Enterprises Vne LLC · Aurora, COBuilt 1976 · S/N D-9938N2201UChrisara Investments LLC · Carson City, NVBuilt 1997 · S/N EA-601N2203LForni Robert · Spring Grove, ILBuilt 1976 · S/N CE-669N2204LMccann Richard H · Shuqualak, MSBuilt 1999 · S/N 29-0209N2205LAerocare LLC · Oak Ridge, TNBuilt 1976 · S/N TE-1083N22069Frank Merle R Trustee · Wasilla, AKBuilt 1982 · S/N 18504368N2206RKahonees Travel Services LLC · Pleasanton, TXBuilt 1968 · S/N T210-0356N2207LHautman John M · Oxnard, CABuilt 1976 · S/N E-915N2208WLets Fly Inc · Wauconda, ILBuilt 2000 · S/N 30-0048N22097Crestair Air LLC · Dover, DEBuilt 1977 · S/N E-1169N2209LOrth Duane C · San Antonio, TXBuilt 1976 · S/N D-9940N2209MGarner Aviation LLC · Tampa, FLFirst renewal noticeBuilt 2000 · S/N 29-0237N2209RPilotsgirl LLC · Goldsboro, NCBuilt 1968 · S/N T210-0359N220BRSimmonds Gary Bert · San Antonio, TXBuilt 1977 · S/N 310R0973N220DBGrosso John A · Princeton Junction, NJBuilt 1999 · S/N 30-0035N220DPMyrick Richard Leon · Williamson, GABuilt 1966 · S/N 380N220GDJoseph M De Lecce Trustee · Prather, CAS/N 414A0459N220HDAce Transport Service Inc · Wilmington, DEBuilt 1975 · S/N 310R0593N220MEBoyle Flying Service Inc · Boyle, MSBuilt 1967 · S/N U206-0797N220MWLampert Aviation LLC · Phoenix, AZBuilt 1977 · S/N E-1063N220RPDanzig Peter B · Menlo Park, CABuilt 1988 · S/N E-2438N220SRBriar Flyer LLC · Bedford, NHBuilt 2002 · S/N 0391N220TCLanger Brent A · Owatonna, MNBuilt 1973 · S/N 18502153N220TJJaco Oil Co · Bakersfield, CAS/N 21063139N220WBWells Propane Inc · Wells, NVBuilt 1974 · S/N 210-60194N220WRExecutive Services Inc · Columbus, MSBuilt 1994 · S/N E-2909N2210RCarroll James K · Paso Robles, CAS/N T210-0360N2210YN2210y LLC · San Antonio, TXBuilt 2000 · S/N 29-0212N2211QHill Jeffrey A · Bridgeport, WVBuilt 1968 · S/N 421A0011N22121Registration Pending · Georgetown, TXRegistration pendingBuilt 1972 · S/N 21059711N22131Kraxberger Rick R · Kasilof, AKBuilt 1976 · S/N 18503074N2214Q421 Partners · Delphi, INBuilt 1968 · S/N 421A0014N2215TBackcountry Wagons LLC · Kalispell, MTBuilt 1968 · S/N 185-1367N2215YNaran Ashish H · Brookhaven, GABuilt 2000 · S/N 30-0049N22166Reading Jared T · Uvalde, TXBuilt 2000 · S/N 29-0225N2216FSummit North LLC · Anchorage, AKBuilt 1982 · S/N U20606504N2216URegistered aircraftBuilt 1974 · S/N U20602355
Back to AD 86-13-04 R3