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.

N60CGSaj Aviation LLC · Reading, PABuilt 1980 · S/N 318052206N60CSAir Flight Enterprises Inc · South Daytona, FLBuilt 1958 · S/N 24405N60DCCmsjet Sales LLC · Union Lake, MIBuilt 1980 · S/N 6007978061234N60DVDelta Victor LLC · Plano, TXBuilt 2000 · S/N 20053N60FDBarnstorm Aero Inc · Sacramento, CABuilt 1983 · S/N 718N60GAGlidewell Aviation Inc · Parkland, FLBuilt 1978 · S/N 17271354N60GLMiko Pawel Marcin · Santee, CABuilt 1978 · S/N 0806N60GWBangert Computer Systems Inc · Shawnee, KSBuilt 1969 · S/N 60-0030N60HEagle Flight Squadron Inc · East Orange, NJBuilt 1973 · S/N 17261653N60HASteeneck Robert T · Washougal, WABuilt 1989 · S/N 219N60HCKing Winn K · Gladewater, TXBuilt 1996 · S/N 0287N60HFTexas Flying Club Inc · Bryan, TXBuilt 1977 · S/N 17270210N60HUOne Pft LLC · Denton, MTBuilt 1996 · S/N 1321N60HYAnderson James D · Russell, KSBuilt 2002 · S/N 2186N60JBHarmon Eagle LLC · Albuquerque, NMBuilt 1979 · S/N 483-79N60JJGauss Karl F · Tully, NYBuilt 1976 · S/N 14175N60JKHiner Kirk J · Kenyon, MNBuilt 2004 · S/N 142N60JLLeluc Jerome · Fort Worth, TXBuilt 1985 · S/N 5086N60KDBegeman Daniel L · Littleton, COBuilt 2007 · S/N 25620N60KRRhea Keith H · Peck, KSBuilt 2014 · S/N 74099N60KSMay Phillip Edward · Florence, ALBuilt 1978 · S/N 60-0560-182N60LFNorthwoods Air LLC · Orono, MEBuilt 1978 · S/N 27-7854111N60LGEgmond Aircraft LLC · Lewes, DEBuilt 1978 · S/N 2169N60LMNb Airplane Inc · Ithaca, NYBuilt 1979 · S/N 61P06197963280N60LRBlake W Preston · Gainesville, FLBuilt 2003 · S/N 929-2003N60LYLeon Roberts Enterprises LLC · Vienna, VABuilt 1965 · S/N 32-10N60MBCurry Arnold J · Houston, TXBuilt 1966 · S/N 27-3544N60MRHansen Charles R · Covington, TNBuilt 1978 · S/N GA-7-0060N60NAHampden Aviation Services Inc · Northampton, MABuilt 1980 · S/N 28-8116049N60NCBalsley Matthew · Rowlett, TXS/N 616N60PLPapa Lima LLC · York, NEBuilt 1967 · S/N 32-870N60PRHarben Grover III · Gainesville, GABuilt 1978 · S/N 60-0490-159N60RBShrode Rafe C · Jewett, TXBuilt 1955 · S/N 22-2761N60RTPaap Patrick · Menifee, CABuilt 1995 · S/N 658-320-402 FBN60SSDhone Shridhar · Livermore, CABuilt 1968 · S/N 17257479N60TAAero Elite LLC · Springfield, MOS/N 31-7552094N60TBMoffet Brian · Santa Cruz, CAS/N 502N60TTOurhappyfamilyplane LLC · Mason, OHBuilt 1979 · S/N 32-7940151N60UMWbyaa LLC · Saline, MIBuilt 1969 · S/N 28-11347N60UPBrietigam Charles T · Meridian, IDBuilt 2010 · S/N CTB-3N60VBVvs Implements LLC · Wilmington, DES/N 60-0182-080N60VWNix William C · Sterling, COBuilt 1996 · S/N 100N60WEVeillon Joseph B · Alexandria, LABuilt 1974 · S/N 352N60WFEngels John · Edmond, OKBuilt 1959 · S/N 24-1635N60WMSmith Ted J · Lakeland, FLBuilt 2000 · S/N 25041N60WRAmbush One LLC · Memphis, TNBuilt 2003 · S/N 24812N60YGLindstrom Dave C · Marinette, WIBuilt 1974 · S/N 17263953N6100DSzostak Edward M · San Diego, CABuilt 1956 · S/N 22-4744N6100JFranklin County Flying Club Inc · Turners Falls, MABuilt 1976 · S/N 28-7615302N6100PSuarez-Alicea Jorge A · Enterprise, ALBuilt 1959 · S/N 24-1198
Back to AD 87-10-06 R1