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.

N8689NHewitt Donald R · Califon, NJBuilt 1971 · S/N 32-7240033N8689VZacheis Henry M · Fairbanks, AKBuilt 1975 · S/N 841-75N8689YBlue Sky Aviators LLC · Winnebago, ILBuilt 1969 · S/N 30-1835N868BBahrns Phyllis Alyene · Effingham, ILBuilt 2007 · S/N 71067N868JDBratton Charles M · Gatesville, TXBuilt 2012 · S/N 070-133/134-941N868KWeber Jennifer R · Bryan, TXBuilt 2011 · S/N BLM-2N868KFSmith Jason · Calliham, TXBuilt 2000 · S/N 3124N868MMUhl Gregory R · Columbus, MSBuilt 2019 · S/N 81733N868PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843949N868PKYellow Therapy LLC · Kalispell, MTBuilt 1982 · S/N 18-8209021N868RTMartin John D · Billings, MTS/N 18-7809119N868SAS O W Aviation LLC · Crystal River, FLS/N 17266439N868TCDlg Enterprises LLC · Iota, LABuilt 2002 · S/N 18281168N868UInter American University Of Puerto Rico · Bayamon, PRBuilt 2026 · S/N 28020268N86901Rudderow Preston Trustee · Anchorage, AKBuilt 1974 · S/N 23-74N8690POrmsbee Bowden · Longmont, COBuilt 1965 · S/N 24-4138N86911Schneberger Bart A · Nome, AKBuilt 1974 · S/N 25-74N86919Latham Ray H · Raymond, WABuilt 1946 · S/N 1281N8691PBagwell Robert B · Sequim, WABuilt 1965 · S/N 24-4139N8691YVan Bladeren John A · Tigard, ORBuilt 1969 · S/N 30-1837N86928Collum Aviation LLC · Milton, FLBuilt 1974 · S/N 32-74N8692DBryan Kirk J · Big Timber, MTS/N 18-6298N8692PKuyoth Christopher J · Lake Orion, MIBuilt 1965 · S/N 24-4140N8692VLohr Martin J · Petersburg, AKBuilt 1975 · S/N 831-75N8692YTedder Ag Technologies Inc · Walsh, COBuilt 1969 · S/N 30-1838N86936Lewis Aviation Inc · Wilmington, DEBuilt 1974 · S/N 444-74N8693VMichael A Levenhagen · North Fort Myers, FLBuilt 1975 · S/N 185-75N8693WPack Timothy W · Blacklick, OHS/N 28-10796N8693YPeregrine Aviation LLC · Winfield, ILBuilt 1969 · S/N 30-1839N86948Guglietta Jon R · Harwinton, CTBuilt 1974 · S/N 147-74N8694DJunek John M · Leonardtown, MDS/N 18-6303N8694NCitadelle Holdings LLC · Palmetto Bay, FLBuilt 1971 · S/N 32-7200009N86950Dale Jane L · Willow, AKS/N 39-74N86953Madden Russell · Graford, TXBuilt 1974 · S/N 152-74N86954Breaking Wind LLC · Alabaster, ALBuilt 1974 · S/N 148-74N86957Swan Creek Flying Club · Ayr, NDBuilt 1974 · S/N 692-74N8695PDurflinger Aviation LLC · Otterbein, INFirst renewal noticeBuilt 1965 · S/N 24-4143N8695WBurr Walker · Redmond, UTBuilt 1964 · S/N 28-10268N8695YPurkinje Ltd LLC · Wilmington, DEBuilt 1969 · S/N 30-1841N86968Crafted Enterprises LLC · Montrose, COS/N 40-74N86969Sperry Sails Inc · Marion, MABuilt 1974 · S/N 695-74N8696VMoynahan Thomas F · Newnan, GABuilt 1975 · S/N 515-75N86974Qualitair LLC Trustee · MichelstadtBuilt 1974 · S/N 145-74N86977Ajs Aviation Inc · Spring Hill, FLBuilt 1974 · S/N 458-74N8697EMaze Bryan · Tulare, CABuilt 1976 · S/N 28-7615148N8697LFried Stephen · Kingston, MABuilt 1969 · S/N 25-5124N8697VFisher Kurt Adrian Trustee · San Luis Obispo, CABuilt 1975 · S/N 833-75N86985Thomas Lucas G · Beebe, ARBuilt 1974 · S/N 44-74N86986Nelson Michael R · Philip, SDBuilt 1974 · S/N 45-74N86989Webb Terry M · Montreal, MOBuilt 1974 · S/N 46-74
Back to AD 87-10-06 R1