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.

N8764YVenture West LLC · Mesa, AZBuilt 1969 · S/N 30-1920N8765CLatitude Aviation LLC · Spring, TXBuilt 1976 · S/N 28-7690161N8765EMoore Alex W · Deep Gap, NCBuilt 1976 · S/N 28-7690203N8765FSmith Nelson · Brighton, IAS/N 28-7790266N8765HN8765h LLC · Carthage, NCBuilt 1993 · S/N 1246N8765YBrady William H · Moorestown, NJBuilt 1969 · S/N 30-1921N8766DRatliff Steven L · Spring Grove, PABuilt 1958 · S/N 22-5952N8766ELoose Larry A · Jamestown, NDBuilt 1976 · S/N 28R-7635213N8766PStephens Lloyd G · Saratoga, CABuilt 1965 · S/N 24-4216N8766WKeesling Roger Lynn · Starkville, MSS/N 28-10306N8767DGriffith Scott G · Newnan, GABuilt 1958 · S/N 22-5953N8767NAbernathy Larry D · Vernon, TXBuilt 1969 · S/N 28-25591N8767PGen-One Aviation LLC · Carlsbad, NMBuilt 1965 · S/N 24-4217N87687Dittmer Dean C · Bennett, COBuilt 1967 · S/N R172-0248N8768FReynolds Darryl G · Wills Point, TXBuilt 1962 · S/N 62-0092N8768KRegistered aircraftS/N 32-7340149N8768NHammonds Benjamin J · Newcomerstown, OHS/N 28-25589N8768PGliege Allan C · Middleton, IDBuilt 1965 · S/N 24-4218N8768WMeyer Eric W · Derby, KSBuilt 1964 · S/N 28-10309N8768YVst Aviation LLC · Ball Ground, GAS/N 30-1924N8769WDublin Aviation Corp · Columbus, OHRevoked, canceledBuilt 1964 · S/N 28-10310N876AJKnapp Adam G · Steamboat Springs, COBuilt 2005 · S/N 25423N876CMRybarczyk Mathias M · Burlington, WIBuilt 2020 · S/N 018142001N876EBLewis Aviation Inc · Wilmington, DEBuilt 2009 · S/N 82803N876EEEwing Robert A · Cedar Grove, NJBuilt 1971 · S/N 32-7100023N876LSThird Coast Aircraft LLC · Mobile, ALBuilt 2001 · S/N SRG 059N876SCFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881745N876TBHenderson Tyler J · Goodland, KSBuilt 1999 · S/N 20363N876TUDudley Aviation Services LLC · Wilmington, DEBuilt 2005 · S/N 7030N8770PGores Thomas J · Franklin, WIS/N 24-4220N8771CSummit Aviation LLC · Spokane, WABuilt 1976 · S/N 28-7690163N8771WRegistration Pending · Elkhorn, WIRegistration pendingBuilt 1964 · S/N 28-10313N8771YNation Jimmy D · Decatur, TXBuilt 1969 · S/N 30-1927N8773CScott Ansell E · San Diego, CAS/N 28-7690164N8773NBeen Flyin LLC · Colchester, CTBuilt 1969 · S/N 28-25597N8773PMcfly Cornhusker LLC · Sarasota, FLBuilt 1965 · S/N 24-4224N8773WDurrence Glenn W · Glennville, GABuilt 1964 · S/N 28-10315N8773XFranks Kenneth D · La Grande, ORBuilt 2018 · S/N 82329N8774DKeeler Michael E · Riverdale, MIS/N 22-5962N8774FReynolds Darryl G · Wills Point, TXBuilt 1962 · S/N 0098N8774WMeadows Dan R · Douglasville, GABuilt 1964 · S/N 28-10317N8775NPerez Jeremiah · Fort Worth, TXBuilt 1969 · S/N 28-25599N8776DThielen Andrew W · Marion, IABuilt 1958 · S/N 22-5964N8777NDaniel Adam Christopher · Sanford, NCBuilt 1969 · S/N 28-25601N8777WHendi Aviation LLC · New Castle, COBuilt 1964 · S/N 28-10321N8777YSilver Ridge Inc · Wilmington, DEBuilt 1969 · S/N 30-1933N8778LRobertson Crop Dusting Service Inc · South Haven, MIBuilt 1972 · S/N 25-5467N8778MSchroemer Theodore J · High Point, NCBuilt 1963 · S/N M-208N8778PTrammell Shaun · Broken Arrow, OKBuilt 1965 · S/N 24-4229N8778WBeery Milo A · Clarinda, IABuilt 1964 · S/N 28-10322
Back to AD 87-10-06 R1