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.

N5351TBie Leasing LLC · Hawkinsville, GABuilt 1972 · S/N 32-7240105N53521Sprague Wolcott E · Westlake Village, CABuilt 2002 · S/N 3257284N5352DN5352d LLC · Costa Mesa, CABuilt 2002 · S/N 2844079N5352LStinson Jonathan L · Douglas, GABuilt 1968 · S/N 28-4655N53533Tfw Enterprise Holding LLC · New York, NYS/N 2843579N5353FAllegany Aviation LLC · Tonawanda, NYBuilt 1976 · S/N 28-7790096N5353GG & M Aircraft Inc · Wheat Ridge, COS/N 2844078N5353UTurbo Arrow Aviation LLC · Knoxville, TNBuilt 2002 · S/N 3257275N5353WYeager Brian · Locust Grove, GABuilt 1962 · S/N 28-416N5354KWassum Kevin Leroy · Apollo Beach, FLBuilt 2005 · S/N 3255033N5354VHowe Andrew · Wshngtn Xing, PABuilt 2002 · S/N 3257298N53550Kansas City Aviation Center Inc · Olathe, KSS/N 2843451N53558University Of Illinois · Savoy, ILBuilt 2002 · S/N 2844083N5355LSeward Joe T Jr · Fairmount, INBuilt 1968 · S/N 28-4658N5356FFly By Knight Inc · Hammond, LANon-citizen corporation, flight hours not reportedBuilt 1976 · S/N 28-7715107N5356LLehuta Steven C · Brunswick, OHBuilt 1968 · S/N 28-4659N5356XSkywest Leasing Inc · St George, UTS/N 2843521N5356YMoore Aviation Inc · Beaver Falls, PABuilt 2002 · S/N 2843528N53572Arb Aviation LLC · Palm Harbor, FLBuilt 2002 · S/N 3246208N5357DYadair Inc · Lauderdale Lakes, FLBuilt 2002 · S/N 2843537N5357NSkywest Leasing Inc · St George, UTS/N 2843519N5357WJones Michael A · Greer, SCBuilt 1962 · S/N 28-421N53580Synergy Aircraft Sales LLC · Bloomington, ILBuilt 2002 · S/N 2844087N5358FAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2003 · S/N 3257312N5358LTwidwell Jon J · Olathe, KSS/N 28-4661N53592Gulfstream Design Associates Inc · Delray Beach, FLBuilt 2003 · S/N 3257317N5359FWashington Fliers Club Inc · Washington, IABuilt 1976 · S/N 28-7790098N5359LFirst Flight Corp · San Diego, CABuilt 1968 · S/N 28-4663N535GWBruno Anthony · Omaha, NEBuilt 1977 · S/N 28R-7703269N535TWJohnson William · New Wilmington, PABuilt 1973 · S/N 28R-7335381N5360KN5360k LLC · Lebanon, MOBuilt 2002 · S/N 3246207N5360LKitzmiller Peter Charles · Seattle, WAS/N 28-4664N5360WShaffer Thomas D · Round Rock, TXS/N 28-425N5361JJones David F · Murfreesboro, TNS/N 3257301N5361NKdb LLC · Underwood, IABuilt 2003 · S/N 2843549N5361WRoberts Misty L · Fountain Hills, AZBuilt 1962 · S/N 28-426N5362FPetros Michael · Chandler, AZBuilt 1976 · S/N 32-7600024N5362LTiedemann Douglas A · Skaneateles, NYBuilt 1968 · S/N 28-4667N5362UHebert Loree W Jr · Saint Francisville, LABuilt 2003 · S/N 2843555N5363JPulliam Joe Clinton Jr Trustee · Pilot Point, TXBuilt 2003 · S/N 2843559N5363LTeehee Max L · Searcy, ARBuilt 1968 · S/N 28-4668N5363SOwens Scotty · Crofton, KYBuilt 1970 · S/N 28-7125104N53646Fhas LLC · Cassopolis, MIS/N 3246214N53651Christiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 2843565N53668Xtra Aviation LLC · Redwood City, CABuilt 2003 · S/N 3255009N5366FGoodrich James · Jacksonville, MOBuilt 1976 · S/N 28-7715111N5366LDurnal William H · Washington, NCBuilt 1968 · S/N 28-4672N5366WM & S Aviation LLC · Lebanon, MOBuilt 2003 · S/N 2843552N53672Byrd Kristopher R · Laurel, MSS/N 3232007N5367FBlackburn Kenneth P Trustee · Dubuque, IABuilt 1976 · S/N 28-7790100
Back to AD 87-08-08 R3