OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,001

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.

N1695RLehne Michael · Portland, ORBuilt 1978 · S/N R18200519N1696GRives James · Moore Haven, FLBuilt 1968 · S/N 197N1696JHardin John M · Terrell, TXS/N 28-24102N1696RMoore Alan · Glenwood, ARS/N R18200520N1696TAircraft 1821 LLC · North Charleston, SCS/N 28-7125013N1697R & W Aviation LLC · Owasso, OKBuilt 1991 · S/N 001N1697PConnolly Joseph III · Redding, CABuilt 1954 · S/N 22-2483N1698Davis Philip L · Spring Hill, TNBuilt 1969 · S/N FM-1N1698JFastglass Aviation LLC · Fenton, MOBuilt 2000 · S/N GLASAIR 2303N1698PJobe Kevin D · Sutton, AKBuilt 1954 · S/N 22-2484N1698RRussell Robert Q · Genoa City, WIBuilt 1978 · S/N R18200521N1699RMacdonald Eric J · Belleville, MIBuilt 1978 · S/N R18200522N1699TBurgess Frank A Jr · Durham, NCS/N 28-7125016N169ABSouthern Cub And Aircraft Restoration LLC · Pensacola, FLBuilt 1968 · S/N 25-4517N169AGSkywest Leasing Inc · St George, UTBuilt 2024 · S/N 2881810N169BDFun Flying LLC · Riverwoods, ILS/N 1706N169BFBurklund Joel · Minneapolis, MNBuilt 1995 · S/N 1392N169BRReyna Benjamin M · Bulverde, TXBuilt 2005 · S/N 2019N169BTAtkison Keith · Centre, ALBuilt 1966 · S/N 28-3776N169BWFarris Frederick J · Sandpoint, IDBuilt 1978 · S/N 32R-7885080N169CSChavi LLC · Fredericksburg, TXBuilt 2015 · S/N 2407N169DBFrench David D · Tallahassee, FLBuilt 1969 · S/N 28R-35150N169DDFlughafen Skyport Ltd · Wilmington, DEBuilt 2001 · S/N 455-2001N169DMMost Toys Wins LLC · Joliet, ILBuilt 1995 · S/N 5330N169ETerrell Joe W III · Anchorage, AKBuilt 1966 · S/N 2531N169ECFirst Eclipse Limited · Richmond, VABuilt 1980 · S/N 172RG0515N169EXFlying Squirrel Aviation LLC · Wilmington, DES/N 169N169EZMallory Jessica Lynn · Anchorage, AKBuilt 1976 · S/N 927-76N169FLBlue Moon Holding Co LLC · Boca Raton, FLS/N 17700047N169GACut And Snip Flyers LLC · South Weber, UTBuilt 1993 · S/N 2108N169GSScott Gary L · Kings Beach, CABuilt 2022 · S/N 1165169N169HCButterfly Wings Of Miami LLC · Miramar, FLBuilt 1973 · S/N 17262693N169JPBoggs Mitchell · La Russell, MOBuilt 1972 · S/N 28R-7235262N169JRHull Terri L · Weirsdale, FLBuilt 2010 · S/N 24081N169LHFarmingdale State College · Farmingdale, NYBuilt 2020 · S/N 2881375N169LPLcc East LLC · Freehold, NJBuilt 1999 · S/N 172S8234N169MGeorge Michael · Springfield, ILBuilt 1996 · S/N 034N169MECc Aviation Inc · Tracy, CABuilt 2000 · S/N 172S8449N169MJPlane Metrics LLC · Fort Worth, TXBuilt 2011 · S/N 80501N169RVFoster John O Jr · Hillsboro, ORBuilt 2013 · S/N 90574N169SHEaa Aviation Foundation Inc · Oshkosh, WIS/N 0169N169TSkybolt 3 LLC · Arvada, COBuilt 1973 · S/N T-1N169TRParker Timothy N · Socorro, NMS/N 169N169TSKestrelx LLC · Lake Mary, FLS/N 1694N169WHNoble John E · New Kent, VABuilt 2004 · S/N JC10N169XTalos Aeronautics LLC · Marion, TXBuilt 1993 · S/N 001N16AHendrix Aviation LLC · Benton, ARBuilt 1978 · S/N R18200405N16ABMasselink Ross W · Whitewater, KSBuilt 1967 · S/N 32-40245N16AEKessler Samuel A · Cave Creek, AZBuilt 1984 · S/N 1470N16AKGriffin Steven M · Enterprise, ALS/N 28R-7918057
Back to AD 87-10-06 R1