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.

N8326CNewman Carl D · Phoenix, AZBuilt 1980 · S/N 28-8190152N8326ENorton Eric D · Nauvoo, ILBuilt 1960 · S/N 1582N8326WBarnwell Sam M · Traverse City, MIBuilt 1965 · S/N 28-2504N8326YEastern Stearman Inc Trustee · Leesburg, VABuilt 1967 · S/N 30-1468N83271Nohrenberg Raymond C · Pingree, NDS/N 18-7609061N83272Bowker James D · Willow, AKBuilt 1976 · S/N 18-7609063N83275Perry Scott D · Hood River, ORBuilt 1976 · S/N 18-7609062N83278Hamlin Andrew J · Two Rivers, AKBuilt 1976 · S/N 18-7709047N8327LFill David · Hadley, MABuilt 1980 · S/N 28-8111049N8327RWelsh Rick F · Ewing, VABuilt 1966 · S/N 28-22199N8327WFuture Flying LLC · Manassas, VABuilt 1965 · S/N 28-2506N8327YKaeser Robert E · Lafayette, INBuilt 1967 · S/N 30-1469N8327ZLee Steven M · Redondo Beach, CAS/N 32-8124007N83281Chandler Air Service Inc · Chandler, AZBuilt 1976 · S/N 18-7609064N83283Hayton James B · Sedro Woolley, WABuilt 1976 · S/N 18-7609065N83285Dyches Abigail · Eagle River, AKBuilt 1976 · S/N 18-7609067N8328CSky Craft LLC · Powell, OHBuilt 1975 · S/N 28-7690116N8328DJldp LLC · Chesapeake, VABuilt 1981 · S/N 32R-8129035N8328LArrowhead Helicopter Services LLC · Jourdanton, TXBuilt 1995 · S/N 0210N8328PSale Reported · Lewes, DESale reportedS/N 24-3581N8328UHale Larry D · Charlotte, NCBuilt 1995 · S/N 2567N8328WTolmachev Nikolay A · Anchorage, AKBuilt 1965 · S/N 28-2507N8328YSims Chris · Colleyville, TXBuilt 1967 · S/N 30-1470N8329649 Ranch Co LLC · Odonnell, TXBuilt 1976 · S/N 18-7609068N83299Brewer Danny E Jr · Nikiski, AKBuilt 1976 · S/N 18-7609070N8329VBuck Timothy A · Howland, MES/N 119N8329YHarbock Inc · Wilmington, DEBuilt 1967 · S/N 30-1471N832AKOld City Helicopter Sales LLC · Saint Augustine, FLBuilt 2003 · S/N 1324N832ATDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496312N832CPCivil Air Patrol · Maxwell Afb, ALBuilt 2004 · S/N 18281301N832RMMcbride Christen L · Elgin, TXBuilt 1996 · S/N 42121N832SPRiverside Exteriors Inc · Kalispell, MTBuilt 1983 · S/N 32R-8313001N832TBrown Rod · Ponca, NEBuilt 2002 · S/N 23069CN832TCFour Pines LLC · Grand Rapids, MNBuilt 2003 · S/N 18281269N832TFAir Fleet Holdings LLC · Missoula, MTBuilt 2024 · S/N 2881706N832WWJacobson Richard T · Overton, NVS/N 814N8330LParis Air Inc · Vero Beach, FLBuilt 1980 · S/N 28-8116141N8330RBriggs Michael L · Howell, MIBuilt 1966 · S/N 28-22202N8330VJensen Carla J · Pingree, IDBuilt 1966 · S/N 43N8330WRed Rock Flying School LLC · Mesa, AZS/N 28-2510N8330XHamilton Eddie D · North East, MDBuilt 1980 · S/N 28-8190153N8330ZLuzeski Steven · Collegeville, PABuilt 1980 · S/N 28-8190155N83310Hankerd William J · Port Alsworth, AKBuilt 1976 · S/N 18-7609072N83312Meggers Roger D · Baker, MTBuilt 1976 · S/N 18-7609074N83316Meggers Roger D · Baker, MTBuilt 1976 · S/N 18-7609075N8331CRoanoke Valley Flying Club · Roanoke, VABuilt 1975 · S/N 28-7690117N8331EPats Sales Of Ocala LLC · Ocala, FLBuilt 1981 · S/N 32-8124008N8331LMjl Investment Company Inc · Branchville, NJBuilt 1968 · S/N 17256531N8331PBurbanks Travis R · Tarzana, CABuilt 1963 · S/N 24-3584N8331SFly Aviation Corp · Wilmington, DEBuilt 1982 · S/N 28-8316028
Back to AD 87-10-06 R1