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.

N2143BLance Aviation Corp · Houston, TXBuilt 1978 · S/N 32R-7987028N2143CPlane Fun Inc Tr Trustee · Snellville, GABuilt 1973 · S/N 423-74N2143PMcgrath Susan · Morehead City, NCBuilt 1979 · S/N 28-7911103N2143TRahim Shamim Inc · Jacksonville, NCBuilt 1971 · S/N 28-7125454N2143YBk Aviation Services LLC · Graford, TXBuilt 1979 · S/N 28-7916357N21441Paris Air Inc · Vero Beach, FLBuilt 1978 · S/N 28-7916040N21442Ducote Randal J · Parker, COBuilt 1978 · S/N 28-7990048N21443Compton James R · Boise, IDBuilt 1978 · S/N 28-7990049N21446Ham Todd O · Opdyke, ILBuilt 1974 · S/N 17263946N21449Curry Robert B · Delphos, OHBuilt 1978 · S/N 32-7840186N2144NPaxton Matthew P · Ketchum, IDBuilt 1979 · S/N 28-7911096N2144THilds Marine Service Inc · Pasadena, MDBuilt 1971 · S/N 28-7105166N2144VAnson Air LLC · Sugar Land, TXBuilt 2003 · S/N 18281276N2144WHansen Kenneth L · Kimballton, IABuilt 1979 · S/N 28-7916331N21454Textron Aviation Inc · Wichita, KSBuilt 2003 · S/N 18281228N21455Drewett Edward A · Many, LABuilt 1974 · S/N 17263950N21459N21459 LLC · Farmington Hills, MIBuilt 1978 · S/N 32R-7887212N2145FSmith Jeffrey D · Hamilton, GAFirst renewal noticeBuilt 1972 · S/N AA5-0017N2145MHanscom Afb Aero Club · Hanscom Afb, MAS/N 28R-7837069N2145NRaschio Ernesto G · Miami, FLBuilt 1979 · S/N 32-7940034N2145RCabernet To Cactus LLC · Scottsdale, AZBuilt 2003 · S/N T20608427N21469Blubaugh Patrick S · Inyokern, CABuilt 1978 · S/N 32R-7887214N2146AZhukov Igor · Live Oak, FLBuilt 2003 · S/N 18281265N2146TBreitfelder Nicholas A · Durango, IABuilt 1971 · S/N 28-7125546N2146XGalloway Robert L III · Cypress, TXBuilt 1997 · S/N 24-3413N21471Gourley Adam C · La Porte, INBuilt 2000 · S/N 3426N2147DRegistered aircraftBuilt 1978 · S/N 28-7911034N2147GAviation Capital Management LLC · San Jose, CABuilt 1978 · S/N 28-7916178N2147KAgati Inc · Chicago, ILBuilt 1978 · S/N 32-7940020N2147NN701bt LLC · Carmel, INBuilt 1979 · S/N 32-7940035N2147PStevens Nicholas · Fort Collins, COBuilt 1979 · S/N 32-7940042N2147TSchavone Loren A · Fullerton, CABuilt 1971 · S/N 28-7125547N2147WMeyer Ronnie G · Sidney, NEBuilt 1974 · S/N M-1520N21481Houston Christopher T · Webster, NYBuilt 1978 · S/N 28-7916044N21485Dipzinski Victor L · Clio, MIFirst renewal noticeBuilt 1974 · S/N 17263956N21489D & S Aviation LLC · Spring, TXBuilt 1978 · S/N 28-7990050N2148BKaroudjian David · Savannah, GAS/N 32R-7987030N2148FRegistration Pending · Wilmington, DERegistration pendingBuilt 1978 · S/N 44-7995157N2148N2 Delta 5 LLC · Oakes, NDBuilt 1979 · S/N 32R-7985069N2148PHorizon Aviation LLC · Buffalo, NYBuilt 1979 · S/N 32-7940043N2148WSav LLC · Shelton, WABuilt 2003 · S/N T20608421N2148ZMalburg Phillip E · Holland, MIBuilt 1979 · S/N 28-7916378N21493Macmillan Robert J · Merritt Island, FLBuilt 2003 · S/N T20608423N21494Dmc Air LLC · West Chester, OHS/N 32R-7887216N21499Kling Clint W · Summerset, SDBuilt 1978 · S/N 32R-7887218N2149DSeaton Brad S · Cache, OKBuilt 1978 · S/N 32R-7985031N2149EPierce Martin H · Big Sky, MTBuilt 1978 · S/N 28-7911044N2149JN2149j LLC · Colorado Springs, COBuilt 1978 · S/N 28-7911061N2149TChandler Air Service Inc · Chandler, AZBuilt 1979 · S/N 28-7911114N214APikago LLC · Moreno Valley, CABuilt 1978 · S/N 17270830
Back to AD 87-10-06 R1