OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,010

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:87-10-06-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
  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.

N5423JRialto Christian Flyers Club Inc · Bradenton, FLBuilt 1980 · S/N 17273787N5423KRandel James B III · Mill Valley, CABuilt 1980 · S/N 17274105N5423PPapp Frank J · Fort Mohave, AZBuilt 1959 · S/N 24-477N54240Pacific Fleet Aviation LLC · Rochester, NYBuilt 1974 · S/N 27-7554034N54245Pacific Fleet Aviation LLC · Rochester, NYBuilt 1974 · S/N 27-7554039N54247Registration Pending · Melbourne, FLRegistration pendingBuilt 1976 · S/N 18-7609049N5424DCarpenter Michael H · Mooresville, NCS/N 20028N5424JFusano Lisa A · La Crescenta, CABuilt 1980 · S/N 17273788N5424PHerreid William L Jr · Prairie Du Chien, WIBuilt 1958 · S/N 24-478N5424QBeltzville Aero LLC · Lehighton, PABuilt 1973 · S/N 17261787N5424SNeely Benson W · Florence, MSBuilt 1971 · S/N 28-7125119N5424VSorbi Aviation Inc · El Cajon, CABuilt 1980 · S/N 172RG0528N54257Meridian Airport Authority · Meridian, MSBuilt 1981 · S/N 17274932N54258Nesbeda Peter J · Marlborough, NHBuilt 1974 · S/N 27-7554046N5425LHamilton Paul DBA · Fresno, TXBuilt 1973 · S/N AA5-0325N5425MWong Alex · Hillsborough, CABuilt 1978 · S/N M-2026N5425SBunn James W · New Port Richey, FLBuilt 1980 · S/N R18201570N5425WIrmen Walter Michael Jr · Arlington Heights, ILS/N 28-497N5425YWilson Leif L · Tok, AKBuilt 1964 · S/N 18-8177N5426Vieira Mark · Turlock, CABuilt 2014 · S/N 1001N54266Low Country Skyways LLC · Wilmington, DEBuilt 1989 · S/N 5-18-42N5426FPressley Aviation LLC · New London, NCBuilt 1976 · S/N 28-7715132N5426JMedia Stew LLC · Carson City, NVS/N 17273789N5426MWorthington Aras · Anchorage, AKS/N 001N5426PTromble Tim L · Story, WYBuilt 1958 · S/N 24-480N5426QLen Emery Photography LLC · Springfield, VTBuilt 1973 · S/N 17261789N54273Swanson Gary A · Fort Bragg, CABuilt 1981 · S/N 17274938N5427FRebel Aviation Inc · Liberty, MOBuilt 1976 · S/N 28-7715133N54283Sale Reported · Lewistown, MTSale reportedBuilt 1975 · S/N 18-7509130N54285Monahan Richard J Jr · Budd Lake, NJBuilt 1981 · S/N 17274945N54288Chandler Air Service Inc · Chandler, AZBuilt 1981 · S/N 17274946N5428FSchold Maury W · Stafford Springs, CTBuilt 1977 · S/N 28-7790118N5428WBon Investment Holdings LLC · Zephyrhills, FLBuilt 1962 · S/N 28-500N54290Laguna Verde Leasing Inc · Wilmington, DEBuilt 1981 · S/N 17274948N54291Flight School Of Gwinnett Inc · Lawrenceville, GABuilt 1981 · S/N 17274949N54296Honcho Aircraft LLC · Crosby, TXBuilt 1981 · S/N 17274950N5429FQuick Kenneth C Jr · Burke, VABuilt 1976 · S/N 28-7790119N5429LGardner T Larry · Dickson, TNS/N AA5-0502N5429PSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1958 · S/N 24-483N5429WLafontaine Generator Exchange Inc · La Fontaine, INBuilt 1962 · S/N 28-501N542APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843762N542CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2881051N542EClegg Edward T · Standish, MEBuilt 2008 · S/N 82179N542ECWang Warner Weihsu · Vienna, WVBuilt 2005 · S/N 18281691N542FCooper Nina · Lake Elmo, MNBuilt 2022 · S/N 542N542FLHaffey George F · Fernandina Beach, FLBuilt 1971 · S/N 28-7125374N542GAtlantic Helicopters International Inc · Lewes, DENon-citizen corporation, flight hours not reportedBuilt 1994 · S/N 2459MN542HGraham Jack D · Hamilton, TXBuilt 1976 · S/N 343N542HFPars Avn Corp · Wilmington, DEBuilt 1974 · S/N 28R-7435310N542JPGrauer Keaton · Marysville, KSBuilt 1968 · S/N 28R-30772
Back to AD 87-10-06 R1