OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,413

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-08-08-R3')
    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-08-08-R3')
  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.

N4206TTownsend Rhett · Manakin Sabot, VAS/N 28-7205094N4207GDavis Glenn A · Fair Oaks, CAS/N 28-23878N4207TMisiura Edward Stanley Trustee · Elmhurst, NYBuilt 1971 · S/N 28-7225093N4208RPeh Aviation LLC · Morristown, TNBuilt 1969 · S/N 32-40573N4209RLo-Flyer 235 LLC · Boyle, MSBuilt 1969 · S/N 32-40574N420ARArakelian Arthur DBA · Worcester, MABuilt 2000 · S/N 3257149N420RMCummiskey Ryan J · Jamesville, NYBuilt 2002 · S/N 2843523N420TCBowling Green Flight Center LLC · Bowling Green, OHBuilt 1999 · S/N 2843220N4210JPlamondon Steven J · Lake Leelanau, MIBuilt 1966 · S/N 28-22556N4210RWalle Neil M · Klamath Falls, ORBuilt 1969 · S/N 32-40575N4211J11j Inc · Fort Lauderdale, FLBuilt 1966 · S/N 28-22558N4211RDyson Michael · Duxbury, MABuilt 1969 · S/N 32-40576N4212AEast West Aviation Club · DuffelS/N 32R-7885198N4212RLetkeman Abram · Amarillo, TXBuilt 1969 · S/N 32-40577N4212TAci Medical Management Inc · San Marcos, CABuilt 1971 · S/N 28-7205099N4213RClear Blue Skies Aviation LLC · Warner Robins, GABuilt 1969 · S/N 32-40578N4213TMallard Aviation LLC · Manchester, NHBuilt 1971 · S/N 28-7205100N4215TBaker Michael D · Berlin, PABuilt 1971 · S/N 32-7200011N42161Registered aircraftS/N 28-7425312N42167Howarth Jason A · Lancaster, PABuilt 1974 · S/N 28-7415383N42168Registration Pending · Denton, TXRegistration pendingBuilt 1974 · S/N 28-7415384N4216RJeffordspaul · Naperville, ILBuilt 1969 · S/N 32-40581N4216TExtreme Metals LLC · El Dorado, ARBuilt 1971 · S/N 28-7205102N4217JShuffler David · Kingman, AZBuilt 1966 · S/N 28-22565N4217TBentzen David A · Deer Park, WABuilt 1968 · S/N 28R-30975N4218TGolden Pick LLC · Maple Plain, MNS/N 28-7225096N4219T19t LLC · Columbia, MOBuilt 1971 · S/N 32-7240037N421DLLaplant James R · Newton, IABuilt 1974 · S/N 28-7415326N421DWLandman William L · Snowmass, COBuilt 1979 · S/N 28R-7931044N421MJLevine Jonathan L · Waterford, CTBuilt 2000 · S/N 2843338N4220JHisghman Jonathan G · Waynesboro, VABuilt 1966 · S/N 28-22568N4220RFoster Carl G · Tucson, AZBuilt 1969 · S/N 32-40585N4220TMartin Thomas Arthur · Great Falls, VABuilt 1972 · S/N 32-7240057N4221JKeystone Aviation LLC · Melrose, FLBuilt 1966 · S/N 28-22569N4221TEralet Inc · Middletown, DEBuilt 1971 · S/N 28-7225097N4222JHerrera Justin C · Willits, CAS/N 28-22570N4223JMccormick Brian C · Irvine, CABuilt 1966 · S/N 28-22571N42241Peters Dale M · Naknek, AKBuilt 1974 · S/N 28-7405163N4224RElkins S Investments Inc · Cary, NCBuilt 1969 · S/N 32-40589N4224TKhair Air Aviation LLC · Senoia, GABuilt 1971 · S/N 28-7205105N4225TCulpepper Steven F · Columbus, GAS/N 28-7125592N4226RClearview Farms LLC · Magnolia, NCBuilt 1969 · S/N 32-40591N4226TElledge William L · Glen Saint Mary, FLBuilt 1971 · S/N 28-7125576N4227JRoberts Richard M · Plains, KSS/N 28-22576N4228RRegistered aircraftBuilt 1969 · S/N 32-40593N4228TSmith Jerry Wayne · Monroe City, INBuilt 1971 · S/N 32-7240046N4229TRobinson Lee B · Kerrville, TXBuilt 1971 · S/N 28-7225098N422CDMachedge Flight Sim Training LLC · Pell City, ALBuilt 1981 · S/N 28-8190272N422DJFerrer Michael V · Fort Worth, TXBuilt 1979 · S/N 28-7911281N422EJAdams A David · Tallahassee, FLBuilt 1979 · S/N 28-7990585
Back to AD 87-08-08 R3