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.

N44SDKandle Douglas A · Boise, IDBuilt 2015 · S/N TCQ1007068N44SJHarpreet Sandhu · Livermore, CABuilt 1977 · S/N 0752N44SKCm3 LLC · North Las Vegas, NVBuilt 2004 · S/N 10534N44STTakvorian Sevag · West New York, NJBuilt 1979 · S/N 17271609N44TCKinzie Hon K · Anchorage, AKBuilt 2002 · S/N 9941CCN44TDChristian Joe L · Naylor, GABuilt 1973 · S/N 1000N44TGBlue Water Flying Services LLC · Lumberton, TXS/N 0509N44UGNomadic Aviation LLC · Sheridan, WYBuilt 1991 · S/N 10088CN44UKN44uk Partners LLC · Burlington, WABuilt 2005 · S/N 10969N44VFLorenz Reiff A · Dayton, OHBuilt 2007 · S/N 3FX023N44VTNelson William R · Caldwell, IDBuilt 1994 · S/N 20121N44VVHampton Warrior II Inc · Shelter Island, NYBuilt 1980 · S/N 28-8116009N44WCWhite Eagle Investments LLC · San Jose, CABuilt 1995 · S/N 20242N44WDDemray William S · Northville, MIBuilt 1969 · S/N 30-1860N44WKMaiden Robert M · Williamson, GABuilt 1983 · S/N 11144N44WLLitton Wade N · Townsend, MTBuilt 2026 · S/N 20510N44WMBloomfield Robert C · Anchorage, AKBuilt 1974 · S/N 18-7409095N44WPAnderson Stuart R Jr · Sahuarita, AZBuilt 2015 · S/N ES1N44WTMoore Arlon A · Newcastle, CABuilt 2002 · S/N 23178N44WZWild Blue Yonder LLC · Batavia, OHS/N 729N44XBBrennon Aviation LLC · North Fort Myers, FLBuilt 2002 · S/N 1215N44XCSendero Helicopters LLC · Bandera, TXBuilt 2006 · S/N 11227N44XDDuffer David · Fallbrook, CABuilt 1999 · S/N 1054N44XXFlyboy71 LLC · Kalamazoo, MIBuilt 1979 · S/N 61P07398063362N44YAAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 2004 · S/N 10261N44YGAppelt Jon A · Dayton, NVBuilt 2010 · S/N 21698N44YTJohs Robert W · Palacios, TXBuilt 2020 · S/N 2383N44YUDoane Mica S · Meno, OKBuilt 2011 · S/N 64N44YYYankee LLC · Kasilof, AKBuilt 1979 · S/N 18-7909069N44ZWTurner Robert H · San Diego, CABuilt 1977 · S/N 322-77N45002New England Aviation Air Charters LLC · Plainville, CTBuilt 1980 · S/N 31-8052161N4500FEngle David · Memphis, TNBuilt 1976 · S/N 32R-7680455N4500RWork Edward · Sneads Ferry, NCBuilt 1965 · S/N 28-21199N4500WMagalsky Jacob J · Wilsall, MTBuilt 1980 · S/N 18-8009019N45014Marc Inc · Bolton, MSBuilt 1980 · S/N 31-8052171N4501B70 North LLC · Anchorage, AKBuilt 1980 · S/N 31-8052168N4501EOptima Aviation LLC DBA · Lewisville, TXS/N 17271614N4501HBrown Kevin · San Dimas, CABuilt 1978 · S/N 24-0750N4501JBleem Steven L · Duncan, OKBuilt 1968 · S/N 28R-30355N4501LPleasant Aviation LLC · Mount Pleasant, TXBuilt 1968 · S/N 001N4501RNess James H · Phoenix, AZBuilt 1965 · S/N 28-21200N4503JSkykid Adventures LLC · Cedar Valley, UTBuilt 1968 · S/N 28R-30358N4503YSteppler Dean M · Culbertson, MTBuilt 1971 · S/N 18-8923N4504YCronin Monty A · Gettysburg, SDBuilt 1971 · S/N 18-8924N45050Rav Aviation LLC · Miramar, FLBuilt 1969 · S/N 27-4271N45052Talkeetna Aero Services Inc · Anchorage, AKBuilt 1980 · S/N 31-8152063N4505ASteadman Norman W · Arlington, TXBuilt 1956 · S/N 22-3810N4505RFayal Kenneth E Jr · Bend, ORS/N 28-21205N4505XBlack Hound Aviation LLC · Austin, TXBuilt 1975 · S/N 32R-7680022N4505YGeneral Air Service LLC · Van Wert, OHBuilt 1971 · S/N 18-8925
Back to AD 87-10-06 R1