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.

N14133C I Holdings Ltd Inc · Lewes, DES/N 27-4701N14135Olympiakh LLC · Louisville, KYBuilt 1971 · S/N 27-4702N14138Island Bound LLC · Dunedin, FLS/N 27-4704N14149Ninja Turtle LLC · Orlando, FLBuilt 1971 · S/N 27-4712N1414TThomas Evan C · Lancaster, CABuilt 1985 · S/N 206N1414VMoeller Rita L · Rescue, CABuilt 1974 · S/N 17263559N1415JSale Reported · Irving, TXSale reportedBuilt 1975 · S/N 415N1415USale Reported · Miami, FLSale reportedBuilt 1976 · S/N 17267083N1415XLaramee Michael E · Goldsboro, NCBuilt 1999 · S/N 8119N14167Davis Ronald L Jr · Soldotna, AKBuilt 1974 · S/N 18-7409097N1416ESalem Pilots Association · Salem, ORBuilt 1978 · S/N 17270989N1416TRegistered aircraftS/N 28-7225507N1416UEddy Elizabeth H · Tunbridge, VTBuilt 1976 · S/N 17267084N14175Box Aviation Inc · Montgomery, ALBuilt 1971 · S/N 27-4739N1417TWood Andrew Calvin · Tallahassee, FLBuilt 1972 · S/N 28-7225508N1417UWings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267085N1417VSkyhawk Aviation LLC · Rutherfordton, NCS/N 17263562N14183Osborne Donald R · Fairbury, NEBuilt 1971 · S/N 27-4747N1418JAaa Training LLC · Kalispell, MTBuilt 1975 · S/N 418N1418RHall James E · Shalimar, FLBuilt 1975 · S/N AA1B-0518N1418TZucchi Steven · Ephrata, PABuilt 1972 · S/N 28-7205295N1418VBeverly Flight Center LLC · Middleton, MABuilt 1974 · S/N 17263563N1418XHaskin Kent B · Claverack, NYBuilt 1975 · S/N 28R-7535276N1419CVetrone Troy · Wisconsin Rapids, WIBuilt 1977 · S/N 17702724N1419TBrolan Aviation LLC · Kansas City, MOS/N 28R-7235283N1419XWhitman Aviation LLC · Morganville, NJS/N 32-7540160N141ACGann Steve W · Southaven, MSS/N AA5-0743N141AFSmith Michael J · Brandon, MSBuilt 1995 · S/N 0014N141ANWells Ryan · Holdrege, NES/N 32-7940062N141AREpp Robert Jackson · New Kent, VAS/N 8060CN141AVMavity Michael D · Phoenix, AZBuilt 1984 · S/N 28-8490107N141BHBob Hannah Aviation LLC · Caldwell, IDBuilt 2022 · S/N 623-2022N141CCDavis Steven M · Eastsound, WABuilt 1991 · S/N 01N141CDSky Helicopters Inc · Desoto, TXBuilt 2023 · S/N 30091N141CGJackson Glenn E · Byron, MNS/N 683RN141CHRegistered aircraftBuilt 1979 · S/N 324-79N141CJKramer Benjamin P Trustee · Carson City, NVBuilt 1985 · S/N F8L-518N141CLFulbright Charles M · Toccoa, GABuilt 1967 · S/N TD-692N141CMMoran Christopher C · Colleyville, TXBuilt 2022 · S/N 42310N141DDCox Aviation Services LLC · Acworth, GABuilt 1999 · S/N 3246132N141DFNaumann Reuben D · Blackwell, MOS/N 19011CN141EGage Christopher P · Coeur D Alene, IDBuilt 2020 · S/N 001N141ERStein Richard M · Sierra Vista, AZS/N 1335N141FAnderson Jon J · Hill City, SDBuilt 1998 · S/N 1400N141FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 2019 · S/N 2881158N141FQCross Daniel · Windham, NHS/N 28-8290176N141FWSchultz Frank R · Lafayette, COBuilt 2011 · S/N 22898N141JStocks Judy K Trustee · Lubbock, TXBuilt 1999 · S/N 23376N141JGCardinal 1jg LLC · Bakersfield, CABuilt 1968 · S/N 17700930N141JSGeurin Ronnie C · Murray, KYBuilt 1979 · S/N 383-79
Back to AD 87-10-06 R1