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.

N8952NCircle K Supply Chain Solutions LLC · Knoxville, TNBuilt 1969 · S/N 32-40754N8952WPollock William J · Agawam, MABuilt 1964 · S/N 28-10525N8953WKinser Aviation LLC · Guthrie, OKBuilt 1964 · S/N 28-10526N8954CTeamco Aviation LLC · Saint Petersburg, FLS/N 32R-7680146N8954NSabbagh Mouin F · Missouri City, TXBuilt 1969 · S/N 32-40757N8955NRichart Nicholas J · Clever, MOBuilt 1969 · S/N 32-40758N8955WSides Michael E · Bartley, NEBuilt 1964 · S/N 28-10529N8956JBays Bob D · Jasper, MOBuilt 1965 · S/N 28-2977N8956WHalleck Brandon R · Terre Haute, INBuilt 1964 · S/N 28-10530N8957CTracon Aviation LLC · Winter Springs, FLBuilt 1976 · S/N 28-7625137N8957JAirplane LLC · Farmington, UTBuilt 1965 · S/N 28-2978N8957NN8957n Inc · Wilmington, DEFirst renewal noticeBuilt 1969 · S/N 32-40761N8958CWinter John T · Tucson, AZBuilt 1976 · S/N 28-7625138N8958JDavis William M · New Lenox, ILBuilt 1966 · S/N 28-2979N8959JRegistration Pending · Fairmont, WVRegistration pendingS/N 28-2980N895CKVigee John E · Southside, ALBuilt 1978 · S/N 32RT-7885059N895TCHeisecke Raul Torres · Tyler, TXS/N 3246004N8960JRegistered aircraftFirst renewal noticeBuilt 1965 · S/N 28-2982N8960NSkyriders Inc · Pocatello, IDBuilt 1969 · S/N 32-40771N8960YSmith Jeremiah R · Fort Wayne, INBuilt 1978 · S/N 32R7887047N8961CHuguenard Jefferson · Alpharetta, GABuilt 1976 · S/N 28-7615135N8962JStory Allen D · Arlington, TXBuilt 1965 · S/N 28-2984N8962NGallen Peter · Wilmington, DEBuilt 1969 · S/N 32-40773N8963NBaker Daniel T · Jackson, OHBuilt 1969 · S/N 32-40774N8964W3720 To 1 Inc · Greenwood Village, COBuilt 1964 · S/N 28-10540N8965JN8965j LLC · Anchorage, AKBuilt 1966 · S/N 28-2987N8965WWarlick Bradley Q · Negaunee, MIBuilt 1964 · S/N 28-10541N8966JBrown Bradford K · Leoti, KSBuilt 1965 · S/N 28-2988N8966NCherokee Six LLC · Minburn, IABuilt 1969 · S/N 32-40776N8967JJust Plane Fun LLC · Sunrise, FLBuilt 1965 · S/N 28-2990N8967TKellys Flying Service LLC · Warrensburg, MOBuilt 1981 · S/N 28-8190209N8968JStevens Raymond W · Norfolk, VAS/N 28-2991N8968WRc Skywagon LLC · Miami, FLBuilt 1964 · S/N 28-10545N8969CStrahl Guenter H · Jackson, NJBuilt 1976 · S/N 28-7690173N8969NMatanane Roke C · Barrigada, GUBuilt 1970 · S/N 32-40769N8969WPostage Robert · Chapel Hill, NCBuilt 1964 · S/N 28-10546N896ACAri Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881414N896CFMiles Air Leasing LLC · Canonsburg, PABuilt 1968 · S/N 28-4852N896DFVenture North Aviation LLC · Cloquet, MNBuilt 2024 · S/N 2881696N8970JAll Tech Machine & Tool Inc · Greenwood, ARBuilt 1965 · S/N 28-2993N8970WYoungblood Wade · Corsicana, TXBuilt 1964 · S/N 28-10548N8971JSwearingen Louis S · Summerfield, FLBuilt 1965 · S/N 28-2994N8972CBosn Richard O · Scottsbluff, NEBuilt 1976 · S/N 28-7690174N8972JPascua Jonathan J · Coventry, RIBuilt 1966 · S/N 28-2995N8972WIma Pilot LLC · Sauk Rapids, MNBuilt 1964 · S/N 28-10550N8973JMuleshoe Flight Club LLC · Muleshoe, TXBuilt 1965 · S/N 28-2996N8973WPlasek Christopher · Owatonna, MNBuilt 1966 · S/N 28-10810N8974WRassmussen Troy · Fayetteville, NCBuilt 1966 · S/N 28-10811N8976JGreat Plains Aviation LLC · Lincoln, NEBuilt 1966 · S/N 28-2999N8977JJohnson Bradley F · West Babylon, NYBuilt 1966 · S/N 28-3000
Back to AD 87-08-08 R3