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.

N8950UManley Steven T · Dallas, TXBuilt 1965 · S/N TD-641N8950WEthington Scott · Emmett, IDS/N 28-10523N8951DChadwick Stewart · Yuba City, CABuilt 1958 · S/N 22-6114N8951JMoehle Colleen M · Lincoln, ILBuilt 1966 · S/N 28-2971N8951PJames Donnie E · Collinsville, ALBuilt 1966 · S/N 24-4408N8952CZell Zulu LLC · Greensboro, NCBuilt 1976 · S/N 32-7600010N8952NCircle K Supply Chain Solutions LLC · Knoxville, TNBuilt 1969 · S/N 32-40754N8952PBreckenridge Lester James Jr Trustee · Appleton City, MOBuilt 1966 · S/N 24-4409N8952WPollock William J · Agawam, MABuilt 1964 · S/N 28-10525N8953DVassal Ministries · North Pole, AKBuilt 1958 · S/N 22-6112N8953PTendie Time Flying LLC · San Diego, CABuilt 1966 · S/N 24-4410N8953WKinser Aviation LLC · Guthrie, OKBuilt 1964 · S/N 28-10526N8954CTeamco Aviation LLC · Saint Petersburg, FLS/N 32R-7680146N8954NSabbagh Mouin F · Missouri City, TXBuilt 1969 · S/N 32-40757N8954PKramer Kartie K · Mckinney, TXBuilt 1966 · S/N 24-4411N8955NRichart Nicholas J · Clever, MOBuilt 1969 · S/N 32-40758N8955PPropwash LLC · Princeville, ILBuilt 1966 · S/N 24-4412N8955WSides Michael E · Bartley, NEBuilt 1964 · S/N 28-10529N8955YCarter Howard A III · Stafford, VABuilt 1971 · S/N 39-115N8956Martini Philip D · Bethel Park, PABuilt 1973 · S/N 123-74N8956JBays Bob D · Jasper, MOBuilt 1965 · S/N 28-2977N8956WHalleck Brandon R · Terre Haute, INBuilt 1964 · S/N 28-10530N8956YDark Side Aeronautical Inc · Wilmington, DEBuilt 1971 · S/N 39-116N8957CTracon Aviation LLC · Winter Springs, FLBuilt 1976 · S/N 28-7625137N8957JAirplane LLC · Farmington, UTBuilt 1965 · S/N 28-2978N8957NN8957n Inc · Wilmington, DEFirst renewal noticeBuilt 1969 · S/N 32-40761N8957PCreedon John · Mc Cormick, SCBuilt 1966 · S/N 24-4414N8957VN8957v LLC · Fort Lauderdale, FLBuilt 1974 · S/N 17264313N8958English John H · Pittsburg, TXBuilt 1973 · S/N 610-74N8958CWinter John T · Tucson, AZBuilt 1976 · S/N 28-7625138N8958DPoulton Daniel D · Belton, SCBuilt 1958 · S/N 226121N8958JDavis William M · New Lenox, ILBuilt 1966 · S/N 28-2979N8958PVan Dyke David M · Portland, ORBuilt 1966 · S/N 24-4415N8958VHyldburg Aviation Inc · Plymouth, MABuilt 1974 · S/N 17264314N89594Executive Aviation LLC · Peoria, AZBuilt 1983 · S/N 17276009N8959JRegistration Pending · Fairmont, WVRegistration pendingS/N 28-2980N8959PMosel Properties LLC · Marrero, LABuilt 1966 · S/N 24-4416N895AGProffetty Stephen D · Bridgewater, MABuilt 2010 · S/N 25235N895DSGuida Associates Consulting Inc · Sandpoint, IDS/N 20530N895TCHeisecke Raul Torres · Tyler, TXS/N 3246004N895VSpurlock Ricky DBA · Jensen, UTBuilt 1958 · S/N 18-6736N8960CChristensen Todd S · Wasilla, AKBuilt 1954 · S/N 18-3261N8960JRegistered aircraftFirst renewal noticeBuilt 1965 · S/N 28-2982N8960NSkyriders Inc · Pocatello, IDBuilt 1969 · S/N 32-40771N8961CHuguenard Jefferson · Alpharetta, GABuilt 1976 · S/N 28-7615135N8961PRegistered aircraftBuilt 1966 · S/N 24-4418N8961VHampton Flying Services LLC · Portsmouth, NHBuilt 1974 · S/N 17264317N8961ZHein-Reece Linda K · Shelton, WABuilt 1973 · S/N 17262110N8962FEmbry Aero Ltd · Greenville, ILBuilt 1973 · S/N 430196N8962JStory Allen D · Arlington, TXBuilt 1965 · S/N 28-2984
Back to AD 87-10-06 R1