OpenAirDocs.org
AD 87-08-08 R3

Registered aircraft · 22,416

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.

N9641KWempen Steven R · Assumption, ILBuilt 1976 · S/N 28-7615221N9641WHoover Anna L · Anchorage, AKBuilt 1967 · S/N 28-23100N9642CBarts Flying Service Inc · Storm Lake, IABuilt 1978 · S/N 28-7816509N9642JSafety First Flying · Murphysboro, ILS/N 28-3870N9642WN9642w Leasing LLC · Corunna, MIBuilt 1967 · S/N 28-23101N9643JHitchings Fred · Chesapeake, OHBuilt 1967 · S/N 28-3871N9643WN9643w LLC · Dover, DEBuilt 1967 · S/N 28-23102N9644JLeckliter Michael A · Murrieta, CABuilt 1966 · S/N 28-3808N9644KLuck Aviation LLC · Glen Allen, VABuilt 1976 · S/N 28R-7635252N9645JLuxury Vacations Inc · Scottsdale, AZBuilt 1966 · S/N 28-3809N9646KHumphreys Garfield · Port Saint Lucie, FLBuilt 1976 · S/N 32R-7680236N9646WOgier Gerard Paul · Hampton, NHBuilt 1967 · S/N 28-23105N9647JNelson Stephen A · Milaca, MNS/N 28-3873N9647WAirplanes Plus Inc · Marathon, FLBuilt 1967 · S/N 28-23106N9648WMccullough Dwayne D · Onancock, VABuilt 1967 · S/N 28-23107N9649JRegistration Pending · Springboro, OHRegistration pendingBuilt 1967 · S/N 28-3876N9649WWard Travis E · Tucson, AZBuilt 1967 · S/N 28-23109N964LJAir Mercury LLC · New Rochelle, NYBuilt 1997 · S/N 3246082N964TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881964N964WCStardust Aviation LLC · Farmingdale, NYBuilt 2001 · S/N 2843462N9650JPalmer Eric · Bowling Green, OHBuilt 1967 · S/N 28-3815N9652KPfeiff Koren T · Chandler, AZS/N 32R-7680238N9652WRegistered aircraftS/N 28-23112N9653JClear Sky LLC · La Grange Park, ILBuilt 1966 · S/N 28-3818N9653WWohl Scott D · Clarkston, WABuilt 1967 · S/N 28-23114N9654JMouton Charles J Jr · Gladewater, TXBuilt 1966 · S/N 28-3820N9655JDunn James Blair Jr · Bumpass, VABuilt 1966 · S/N 28-3822N9656JVolpe Robert · Holiday, FLBuilt 1966 · S/N 28-3823N9657CFrantz Jeffery T Jr · Frankfort, ILS/N 32-7840109N9657WNorth Stephen P · Rochester, NYBuilt 1967 · S/N 28-23119N9658KFlying Particles Inc · Livermore, CABuilt 1976 · S/N 28-7690271N9658WGraham Joel A · Marietta, GABuilt 1967 · S/N 28-23120N9659KBell Michael J · Duck Key, FLBuilt 1976 · S/N 28R-7635254N9659WMitchell Matthew · Ypsilanti, MIBuilt 1967 · S/N 28-23121N965ACNaples Air Center Inc · Naples, FLBuilt 1989 · S/N 2841134N965BJNorton Raquel D Trustee · Stateline, NVBuilt 2000 · S/N 3257140N965JBKeevair LLC · Rockaway, NJBuilt 1997 · S/N 3246097N9660WAlaimo Thomas J · Napa, CABuilt 1967 · S/N 28-23122N9661JGrant Michael T · Eugene, ORBuilt 1966 · S/N 28-3829N9663JN9663j LLC · Dallas, TXBuilt 1967 · S/N 28-3877N9665JUmbarger Brian T · Shawnee, KSBuilt 1966 · S/N 28-3834N9665WSoto Osvaldo · Myersville, MDBuilt 1967 · S/N 28-23129N9667JKidd James Allen · Owasso, OKBuilt 1967 · S/N 28-3836N9668CBrandywine Flight School Inc · West Chester, PABuilt 1978 · S/N 28-7816513N9668JBullitt Melissa G · Glenmora, LABuilt 1967 · S/N 28-3837N9669CQuality Aero LLC · East Aurora, NYBuilt 1980 · S/N 28-8016361N9669KMelton Joseph C · Parker, AZS/N 32R-7680240N966DAJoye Richard · Huntsville, ALBuilt 1996 · S/N 2843054N966NDUniveristy Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881924N966RRegenski Paul · Bethany, PABuilt 1980 · S/N 32R-8013133
Back to AD 87-08-08 R3