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.

N76172Rjd Flight LLC · North Canton, OHBuilt 1975 · S/N 17265906N7617DRunyan Colton C · Ashland, ALBuilt 1957 · S/N 22-5321N7617FKeldahl William J · Copperhill, TNBuilt 1976 · S/N 28-7715211N7617JMilner Quinn D · Carbondale, ILBuilt 1968 · S/N 28R-31010N7617PSlack Don S · Stinson Beach, CABuilt 1961 · S/N 24-2828N7617VSoaring Utah Inc · Sandy, UTBuilt 1967 · S/N 1345N7617WWhirl'D Helicopters Inc · Sevierville, TNBuilt 1964 · S/N 28-1581N7618PJaton Bertrand F · Woodville, TXBuilt 1961 · S/N 24-2829N7618SBraun Michael T · Oconomowoc, WIBuilt 1976 · S/N 923-76N7618WExaltium Aviation LLC · Baltimore, MDBuilt 1964 · S/N 28-1582N7619FAinsworth Cavin · Fort Towson, OKBuilt 1976 · S/N 28-7790194N7619GMercer Aviators Inc · Princeton, WVBuilt 1970 · S/N 17259319N7619PFirst Class Auto Remarketing LLC · Lehigh Acres, FLS/N 24-2830N761AZAndover Flight School Inc · Andover, NJBuilt 2008 · S/N 160A-0018N761CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881738N761CCHesston College Aviation · Hesston, KSBuilt 1976 · S/N 28-7690288N761CSParker Todd Steward · Kaysville, UTBuilt 2009 · S/N 90891N761GSSaulsbury Greg F · Nash, TXBuilt 2023 · S/N 91360N761LAIowa Lakes Community College · Estherville, IABuilt 1976 · S/N 172-67476N761RBBastin Robet J · Cadiz, KYBuilt 1999 · S/N 3257107N761WWilliams Richard G J · Labelle, FLBuilt 1976 · S/N 60N7620FRed 5 LLC · Kalispell, MTFirst renewal noticeBuilt 1976 · S/N 28-7790195N7620GDc Aero LLC · Ramona, CABuilt 1970 · S/N 17259320N7620PSopwith James T · Sacramento, CABuilt 1961 · S/N 18-7737N7621EGrey Matter Inc · Valley Springs, CAS/N 24-2168N7621FMeier Scott F · Jupiter, FLBuilt 1976 · S/N 32-7700006N7621GCrewdawg Aviation LLC · Concord, NCBuilt 1970 · S/N 17259321N7621PMckusick Eileen D · Winooski, VTBuilt 1961 · S/N 24-2832N7621SSmith Michael D · King George, VABuilt 1976 · S/N 244-76N7621WAlexander Steven W · Kansas City, MOBuilt 1965 · S/N 28-2913N7622FAeronation Aircraft & Exotics LLC · Lewes, DES/N 32R-7780065N7622GBell Sky Pilots Inc · Reedley, CABuilt 1970 · S/N 17259322N7622JSkylink Aviation Inc · Florissant, MOBuilt 1968 · S/N 28R-31017N7622LHowe Jamie W · Boynton Beach, FLS/N 395N7622PGriffin Robert L Jr · Washington, NCS/N 24-2833N7622WBarnett Donald R · Atoka, TNBuilt 1964 · S/N 28-1586N7623DBaker Donald A · Macedon, NYBuilt 1957 · S/N 22-5327N7623GPlane Sane Aero LLC · Cary, NCBuilt 1970 · S/N 17259323N7623HCowan Drew Paul · Anchorage, AKBuilt 1946 · S/N 12-498N7623JWhite Jeffrey M · Carlsbad, CAS/N 28R-31018N7623RAdamiak Jeffrey · Mount Laurel, NJS/N M-1246N7623SKrejchik Daniel J · Portage, WIS/N 925-76N7623WMidwest Heavy Construction LLC · Pleasant Hill, MOBuilt 1964 · S/N 28-1587N7624GAeroflight Flying Club Inc · Jackson, TNBuilt 1970 · S/N 17259324N7624JBriggano LLC · Mount Pleasant, SCBuilt 1969 · S/N 28R-31102N7624SHovey Gregg Beecher · San Diego, CABuilt 1976 · S/N 207-76N7624WHartley Douglas R · Florence, ALBuilt 1964 · S/N 28-1589N7625FHarbaugh Steven J · Riverside, CAS/N 28-7725091N7625JHuebscher Attila · Flemington, NJBuilt 1968 · S/N 28R-31020N7625MMccowan Kenneth L · Kansas City, KSBuilt 2008 · S/N 5816
Back to AD 87-10-06 R1