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.

N802ERValiair Lc Trustee · Casper, WYBuilt 2003 · S/N 40.306N802FSShelton Shannon · Hampton, GABuilt 1971 · S/N 28-7125398N802GAMns Asset Management LLC · Dover, DEBuilt 1981 · S/N 31-8152103N802PWFlying Mermaid LLC · Aiea, HIBuilt 1981 · S/N 17275194N802RCCollum Aviation LLC · Milton, FLBuilt 1967 · S/N 28R-30299N802RGGandt Robert · Port Orange, FLBuilt 2003 · S/N 70215N802RHKnl Associates LLC · Mansfield, OHBuilt 2017 · S/N 74366N802SASpirit Air Inc · Salmon, IDBuilt 1982 · S/N 2107N802SDFly Blew LLC · Fayetteville, ARBuilt 2004 · S/N T18208239N802SPEdb Air Inc · Wilsonville, ORBuilt 1999 · S/N 172S8107N802UMLawrence Dayle A · Scotia, CABuilt 1972 · S/N 28-7225524N802WHMansfield Heliflight · Milton, VTS/N 0802N80300Ryther Jonathan W · Redlands, CAS/N 17266506N80304Matthews David A · Anchor Point, AKBuilt 1975 · S/N 17266510N80307Hughes Fredrick A · Oklahoma City, OKBuilt 1975 · S/N 17266511N8030DSunrise 6500 Inc · Wilmington, DEBuilt 2004 · S/N 22660N8030JKeystone Aircraft Leasing LLC · Selinsgrove, PABuilt 1978 · S/N 61P-0508-211N8030NWilson Mark A · Havana, FLBuilt 1968 · S/N 28-25275N8030WGosse Luke J · Waterloo, IABuilt 1964 · S/N 28-2096N8030YPaden Frank G · Lawrenceburg, KYBuilt 1966 · S/N 30-1139N8031JCp3 Construction Inc · Los Angeles, CABuilt 1978 · S/N 61P-0509-212N8031POphus Larry N · Big Sandy, MTBuilt 1962 · S/N 24-3278N8031WGraziano Michael A · Freeport, NYBuilt 1965 · S/N 28-2097N8031XRegistration Pending · Camas, WARegistration pendingBuilt 2003 · S/N 60565N8031YBresin Sharon M · Kamas, UTS/N 30-1140N8032Kelly Patrick E · Carson City, NVBuilt 1974 · S/N 1-0020N80322Mt Aviation LLC · Fairbanks, AKS/N 17266518N80326Fly Lugu LLC · Southwick, MABuilt 1975 · S/N 17266520N80327Highland Rim Aviation LLC · Springfield, TNBuilt 1975 · S/N 17266521N8032CAirwego LLC · Wilmington, DEBuilt 1975 · S/N 28-7690097N8032JMchuard LLC · Wilmington, DEBuilt 1978 · S/N 61-0510-129N8032PMorrison Danny G · Louisburg, KSBuilt 1963 · S/N 24-3279N8033Stafy Ronald F · Pottstown, PABuilt 1974 · S/N 1-0021N80331Johnson Shem E · Bonners Ferry, IDS/N 17266525N80332Lamb Joseph M · Conway, ARBuilt 1975 · S/N 17266526N80333Coeytaux Britton Marielle G · St Helena, CABuilt 1975 · S/N 17266527N80335Rawareo LLC · Warsaw, MOBuilt 1975 · S/N 17266529N80336Joyal Alfred N III · Marquette, MIBuilt 1975 · S/N 17266530N80338Maldonado Monell Julio · Carolina, PRBuilt 1976 · S/N 17266532N8033DLevinson Alan J · Delta Junction, AKBuilt 1957 · S/N 22-5558N8033RGoodson Aviation LLC · Tallahassee, FLS/N 31-7952065N80340Tangojuliet Aviation LLC · La Porte, INBuilt 1976 · S/N 17266534N80342Spanaflight LLC · Puyallup, WABuilt 1976 · S/N 17266535N80347Aero Maintenance Inc · Vancouver, WABuilt 1976 · S/N 17266538N80349Giles Jonathan P · Fountain Inn, SCBuilt 1981 · S/N 32R-8213020N8034DMyers Mark · Clovis, NMBuilt 1957 · S/N 22-5559N8034EHill Matthew E · Abingdon, VABuilt 1975 · S/N AA5B0191N8034WFieldgrove Kevin · Monroe, GABuilt 1965 · S/N 28-2101N8034YBerry James V DBA · Hermosa Beach, CABuilt 1966 · S/N 30-1143N8034ZEight Ball Flying Club Inc · Van Nuys, CABuilt 1981 · S/N 32-8206016
Back to AD 87-10-06 R1