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.

N647FLRegistration Pending · Fruitland Park, FLRegistration pendingBuilt 1971 · S/N 28-7125555N647FTFlorida Institute Of Technology · Melbourne, FLBuilt 2013 · S/N 2843707N647MAHot Wings Aviation LLC · Fishers, INBuilt 2026 · S/N 28020267N647SEHaley Kenneth R · Claremore, OKBuilt 2005 · S/N 3232047N647YDFaukner Andrew L · Modesto, CAS/N 287816499N6480JBeaver Douglas G · Harleysville, PABuilt 1968 · S/N 28-4908N6482JSmart Avionics Inc · Marietta, PABuilt 1968 · S/N 28-4910N6483JCimarron Flying Lc · Elkhart, KSS/N 28-4912N6484JMathis Flight Solutions LLC · Dubberly, LABuilt 1968 · S/N 28-4913N6485JYankee Flyers LLC · Berryville, VABuilt 1968 · S/N 28-4914N6485WShades Daniel L · Tumwater, WABuilt 1965 · S/N 28-20560N6486C86 Charlie Corp · Roscoe, ILBuilt 1978 · S/N 32R-7885029N6486WSommerfeld Jordan Maxwell · Kittanning, PABuilt 1964 · S/N 28-20561N6487RNurney Steven P · Fountain Hills, AZBuilt 1966 · S/N 28-21678N6488JWccrt LLC · Enterprise, KSS/N 28-4918N6488R6 Aerospace LLC · Albuquerque, NMS/N 28-21679N6488WKendall Ralph L Jr · Cape Coral, FLBuilt 1965 · S/N 28-20563N6489JPatten Jeffery D · Rapid City, SDBuilt 1968 · S/N 28-4920N648FTFlorida Institute Of Technology · Melbourne, FLBuilt 2013 · S/N 2843708N648NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881164N6490RDunn Christopher E · Amana, IAS/N 28-21681N6490WHanson Orion M · Seabeck, WAS/N 2820566N6491JEleven X Club Inc · Jeffersonville, INBuilt 1968 · S/N 28-4922N6491RGonzales Christian J · Dallas, TXBuilt 1966 · S/N 28-21683N6491WHuddleston Ronnie L · North Vernon, INBuilt 1965 · S/N 28-20567N6492RFagerhaug Jeffrey · Orangevale, CABuilt 1966 · S/N 28-21684N6493JReischmann Jonathan · Palm Bay, FLS/N 28-4924N6493RReifschneider Jay S · Patterson, CABuilt 1966 · S/N 28-21685N6494JKennedy Quincy A IV · Florence, SCBuilt 1968 · S/N 28-4925N6494RTurner Manley W Jr · Fredericksburg, VABuilt 1966 · S/N 28-21686N6495JStp Flight LLC · Saint Paul, MNBuilt 1968 · S/N 28-4926N6495WScheibinger Alois E · Oshkosh, WIBuilt 1964 · S/N 28-20571N6496JBudke Kris J · Osceola, WIBuilt 1968 · S/N 28-4928N6498JKvistad Jerome L · Coon Rapids, MNBuilt 1968 · S/N 28-4930N6499RGoodroe Zachary A · Santa Rosa Beach, FLBuilt 1966 · S/N 28-21692N6499WMarston Benjamin E · Seale, ALBuilt 1965 · S/N 28-20576N649BCFlyport LLC · Crossville, TNS/N 32-7840147N649FTFlorida Institute Of Technology · Melbourne, FLBuilt 2013 · S/N 2843709N649NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881165N649TPGrove John C · Melbourne, FLS/N 28-7921039N64CTFly2dig LLC · Laclede, IDS/N 3240528N64DC64dc LLC · Bishop, CABuilt 1977 · S/N 28R-7703397N64EHRed Stick Brothers LLC · Baton Rouge, LABuilt 1966 · S/N 32-769N64EWLapp Philip D · Weatherford, TXBuilt 1973 · S/N 32-7340089N64MSTilko Stanley L Jr · Butler, PABuilt 1973 · S/N 28-7305466N64STStefenelli Aviation N Tr Inc Trustee · AtterseeBuilt 1973 · S/N 28R7335185N64TZChapel Hill Flying Club DBA · Sanford, NCBuilt 1981 · S/N 28-8216081N64USJc Investors Group LLC · Coral Springs, FLBuilt 1974 · S/N 32-7440122N64WCTrahan Stewart K · Little Rock, ARBuilt 1977 · S/N 32-7740095N64WDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1996 · S/N 3246027
Back to AD 87-08-08 R3