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.

N910SAPersistent Roots LLC · Carpentersville, ILBuilt 1999 · S/N TH-1910N910STRegistration Pending · Beebe, ARRegistration pendingBuilt 1988 · S/N 88-30999N910WWLundell Plastics Corp · Odebolt, IABuilt 2004 · S/N TH-2092N9110QZen Air LLC · Kalispell, MTS/N D-9219N91116Adventure Airways Inc · Homer, AKBuilt 1969 · S/N 20700079N9111MSierra Air LLC · Willow, AKBuilt 1970 · S/N U20601511N9111PBas Part Sales LLC · Greeley, COBuilt 1987 · S/N 4608084N9111QDreifort David A · Brentwood, CABuilt 1970 · S/N CE-330N9112QSkyward Mn LLC · Hutchinson, MNBuilt 1971 · S/N D-9223N9113SBonanza Flyers Of Kansas LLC · Stilwell, KSBuilt 1976 · S/N D-9857N9113ZKenmore Crew Leasing Inc Owner Trustee · Bellingham, WABuilt 1986 · S/N 4608045N9114NOutlier Mt LLC · Kalispell, MTBuilt 1986 · S/N 4608048N91152Dt Pralle Enterprise Inc · Hampton, IABuilt 1975 · S/N 18802022TN91157Garza Aircraft Inc · Harlingen, TXBuilt 1969 · S/N 20700096N91159Drake Richard S · Boise, IDBuilt 1946 · S/N NAV-4-214N91170Paklook Air Inc · Bethel, AKBuilt 1969 · S/N 20700101N9117JBlue Skies Malibu LLC · San Diego, CABuilt 1987 · S/N 4608052N91183Hatch Hyrum G · Gilbert, AZBuilt 1969 · S/N 20700106N9118QBonanza Life LLC · Urbana, ILS/N D-9225N91190Renfro Michael W · Bethel, AKBuilt 1969 · S/N 20700109N911EWeiss Elliott · Fresno, TXS/N 20700747N911GHamilton Jason W · Jefferson, TXBuilt 1966 · S/N D-8198N911GSAir-Ric LLC · Mobile, ALBuilt 1981 · S/N E-1785N911JKRegistered aircraftBuilt 1976 · S/N D-9925N911KRaper David A · Mesa, AZBuilt 1966 · S/N D-8253N911KMWeckbacher Robert K · Mount Pleasant, SCBuilt 1997 · S/N 29-0125N911NKNorton Noel M · Petaluma, CABuilt 1968 · S/N D-8757N911TKAbsolute Precision Chiropractic Inc · Jesup, GABuilt 2004 · S/N 1001N911VGlatt Christopher D · Saint Paul, MNBuilt 1966 · S/N D-8091N9120YEast West Aviation LLC · Joaquin, TXBuilt 1985 · S/N 46-8608010N9121QBehm Darren Wayne · Frisco, TXBuilt 1970 · S/N D-9228N9121XCarter Associates Inc · Burr Oak, MIBuilt 1987 · S/N 4608094N9122LBerman Joshua E · Nashua, NHBuilt 1987 · S/N 4608096N9122NAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1987 · S/N 4608097N9122YCook Auction Co Inc · Clinton, MOBuilt 1985 · S/N 46-8608011N9123VEschenbach Ralph F · Woodside, CAS/N 4608060N91242Nsi Aviation LLC · Ozark, MOFirst renewal noticeBuilt 2000 · S/N 29-0236N9124MBertini Tony B · Du Bois, PABuilt 1994 · S/N 29-0007N9124YAerobox LLC · Seattle, WABuilt 1985 · S/N 46-8608012N9125BStockton Aviation Group LLC · Stockton, CABuilt 1987 · S/N 4608068N9125YKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1976 · S/N U20603324N9126QSks Aviation LLC · Sherman, TXBuilt 1971 · S/N D-9226N9127QDopfel Bruce E · Belle Plaine, KSBuilt 1971 · S/N E-245N9127ZPalmy LLC · Lander, WYBuilt 1987 · S/N 4608059N9128HEriksson Kurt R · Soldotna, AKBuilt 1977 · S/N 18503417N9128QRegistered aircraftBuilt 1970 · S/N E-247N912BMCampbell Ladd M · Signal Mountain, TNBuilt 2008 · S/N E-3871N912GLFtg 929 LLC · Carlsbad, CABuilt 2005 · S/N 1336N912HCivil Aviation Group LLC · Ada, OKBuilt 1966 · S/N TE-143N912HFMcs Aviation LLC · Sylvania, OHBuilt 1990 · S/N CE-1540
Back to AD 86-13-04 R3