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.

N3450WRst Aviation LLC · Vero Beach, FLBuilt 1965 · S/N 32-317N3451KMorehead Matt F · Chico, CABuilt 1967 · S/N 28-23559N3451QCcr Holdings LLC · Rushford, MNBuilt 1977 · S/N 28-7725228N3452KRegistered aircraftBuilt 1967 · S/N 28-23561N3453QEdwards Latas L Jr · St Petersburg, FLFirst renewal noticeS/N 28-7716156N3453WBrown Craig · Vernal, UTBuilt 1966 · S/N 32-321N3454WRoos Paul A · Lake City, FLBuilt 1966 · S/N 32-322N3455RBulut LLC · Los Angeles, CABuilt 1969 · S/N 28-5685N3455WClark James A · Walnut Creek, CABuilt 1966 · S/N 32-324N3457WBas Part Sales LLC · Greeley, COS/N 32-326N3458WBerquist Glenn A · Columbus, MSBuilt 1966 · S/N 32-327N3459KCarrell David W · Pittsburgh, PABuilt 1967 · S/N 28-23566N3459Q51st Aero Squadron LLC · Hoover, ALS/N 28-7790458N3459WPannell Lucas J · Midland City, ALBuilt 1966 · S/N 32-330N345AGSkywest Leasing Inc · St George, UTBuilt 2024 · S/N 2881812N345CQTriple L Airways Inc · Pittsford, NYS/N 28R-8031066N345MKNorth Star Aviation Inc · Mankato, MNBuilt 2019 · S/N 2881262N345SEPlane Fun Inc Tr Trustee · Snellville, GABuilt 2004 · S/N 3257345N345YParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020123N3460RHenninger Mark E · Mill Creek, WABuilt 1969 · S/N 28-5687N3460WCarruth John T · Danvers, MNBuilt 1966 · S/N 32-331N3461RJarriel Investments Inc · Register, GAS/N 28-5689N3462RFor Skies Flying Club Ltd · Martinsville, ILBuilt 1969 · S/N 28-5690N3464KAviation Explorers Post 8000 Inc · Ottawa, KSBuilt 1967 · S/N 28-23567N3464QMac Air Inc · Farmington, MOS/N 28R-7703110N3465KNiepert William · Jacksonville, NCS/N 28-23568N3465RSchissel Todd E · Decorah, IABuilt 1969 · S/N 28-5693N3466KRegistration Pending · Bulverde, TXRegistration pendingBuilt 1967 · S/N 28-23569N3467QHawthorne Mark · Flagstaff, AZS/N 28R-7703111N3467WRobinhood Aero LLC · Southaven, MSS/N 32-340N3468RFlorida Coastal Flying Club LLC · Titusville, FLBuilt 1969 · S/N 28-5695N346DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843833N346JWChastain Jane S Trustee · Greeley, COBuilt 1979 · S/N 28-7911135N346MKNorth Star Aviation · Mankato, MNBuilt 2020 · S/N 2881416N3470RCook Chayil LLC · Granger, INBuilt 1970 · S/N 28-5696N3471MParis Air Inc · Vero Beach, FLBuilt 1978 · S/N 28-7816346N3471RKilpatrick Kerry · Somerset, NJBuilt 1970 · S/N 28-5697N3471WKoranda Amy B · Salem, SCBuilt 1966 · S/N 32-345N3472RKomar Michael J · Danville, PABuilt 1969 · S/N 28-5698N3474MSolverson Britt B · Hazel Green, WIBuilt 1978 · S/N 28-7890303N3476WFletcher Gayle J · Conroe, TXBuilt 1966 · S/N 32-352N3477KToles Richard O · Wolcott, NYBuilt 1967 · S/N 28-23572N3477MCapella LLC · Parkville, MOBuilt 1978 · S/N 28-7890305N3477WStevens Brad · Chandler, AZBuilt 1966 · S/N 32-353N3478KYarber Brandon Tate · Cleveland, TNBuilt 1967 · S/N 28-23573N3478WDouble D Air LLC · Killeen, TXS/N 32-354N347BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2023 · S/N 2881652N347CBMishock Kevin A · Melbourne, FLBuilt 1976 · S/N 32R-7780002N347DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843840N347GWAllen Air LLC · Creola, ALBuilt 1966 · S/N 28-3651
Back to AD 87-08-08 R3