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.

N7108LWeiland Scott J · Howe, INBuilt 1973 · S/N AA5-0408N7108QAnderson Michael · Hillsboro, NDBuilt 1972 · S/N 17260408N7108RChristian Mark A · South Point, OHBuilt 1966 · S/N 28-21805N7108WRed Rock Flying School LLC · Mesa, AZS/N 28-896N7109BEastin Toby M · Jefferson City, MOBuilt 1956 · S/N 22-4326N7109LSimpson Brian · Indian Trail, NCS/N AA5-0409N7109QLawless Bruce A · Lago Vista, TXBuilt 1972 · S/N 17260409N7109SCitation Companeros LLC · Seguin, TXBuilt 1999 · S/N 2952N7109UOyler Joseph B · Kokomo, INBuilt 1964 · S/N 2739N7109WV1 Air Inc · Hibbing, MNS/N 28-897N710APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843766N710AFFranke Stuart A · Hondo, TXBuilt 2023 · S/N 41996N710AWBrown Dustin · Rossburg, OHBuilt 1966 · S/N 32-473N710BWise Matthew A · Chambersburg, PABuilt 1990 · S/N 20017N710BJBluebird LLC · Vestavia, ALBuilt 2003 · S/N 60062N710BTMunoz Tanen J · Lockeford, CABuilt 1970 · S/N 32-1295N710CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881730N710CBPruitt Ron A · Stoneville, NCBuilt 1980 · S/N 1N710CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281710N710CTGibson William V · Aberdeen, MSBuilt 2000 · S/N 80451N710DYAirshare LLC · Anchorage, AKBuilt 2004 · S/N 10383N710EHRatcuffe Howard Clark · Huntsville, UTBuilt 2000 · S/N 23446N710GMaj Enterprises LLC · Missoula, MTBuilt 2013 · S/N 460N710JPSt Matthew Aviation Company LLC · Kalispell, MTBuilt 1979 · S/N 31-7952086N710KVG B Aerial Applications Inc · Slaton, TXS/N T18208291N710LESoaring LLC · Auburn, CABuilt 2012 · S/N 40154N710LGCollette John D · Las Vegas, NVS/N 710N710MEQualitair LLC Trustee · MichelstadtBuilt 1971 · S/N 39-101N710MYInterstate Helicopters Inc · Bethany, OKBuilt 2006 · S/N 11242N710PXAura LLC · Frederick, MDBuilt 2006 · S/N 81788N710RDPurll Samuel B · Mechanicsville, MDBuilt 1966 · S/N 28-21809N710RRMulcahy Michael T · Perris, CABuilt 2000 · S/N 20608106N710RVPuryear Sean T · Graham, TXBuilt 2006 · S/N 40044N710SMExclusive Aeronautics LLC · Las Vegas, NVBuilt 1994 · S/N 27-0174N710SPElite Approach LLC · Chesterfield, MOBuilt 1999 · S/N 172S8106N710UBoard Of Regents Of University Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020229N710VEFour With Two LLC · San Francisco, CABuilt 2003 · S/N 70254N710WHColberg Arien G · Deer Island, FLBuilt 2006 · S/N 40071N7110BSeven-Eleven Brick Inc · Dalton, MNBuilt 1956 · S/N 22-4327N7110PTobias Gregory L · Ottawa Lake, MIBuilt 1960 · S/N 24-2267N7110QLawson Virgil · Sylvar Grove, KSS/N 17260410N7110RQuale Eric L · Everett, WABuilt 1966 · S/N 28-21806N7110YFaust Stanley J · Nashua, NHBuilt 1963 · S/N 30-129N7111DKeyt Jeffrey D · New Providence, NJBuilt 1957 · S/N 22-4969N7111NAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 1977 · S/N 17269101N7111RGreen Michael W · Helena, ARS/N 28-21810N7111WBetter Living Aviation Inc · Wilmington, DEBuilt 1999 · S/N 18280550N7111YBritt Robert J · Au Gres, MIBuilt 1963 · S/N 30-130N71128Eastern Stearman Inc Trustee · Leesburg, VABuilt 1972 · S/N 28-7225450N7112CEmbry Vantha C · Knoxville, TNS/N 28-7690056
Back to AD 87-10-06 R1