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.

N9298PBlackhawk Airventures LLC · Wilmington, DEBuilt 1997 · S/N 3246088N9298WUniversal Avn Inc · La Cygne, KSBuilt 1967 · S/N 28-10975N9299BBird Acquisition LLC · Phoenix, AZBuilt 1998 · S/N 2843116N9299JLucas Steven R · Canton, OHBuilt 1966 · S/N 28-3389N9299XSchoepel Alexandra E Trustee · Templeton, CABuilt 1997 · S/N 3257021N929AArcher Aero LLC · Wilmington, DEBuilt 2015 · S/N 2843803N929DJA And S Flying Services Inc · Bristol, VABuilt 2004 · S/N 3257344N929PABird Acquisition LLC · Phoenix, AZBuilt 1999 · S/N 2843299N929SMAir Manos LLC · Mesa, AZBuilt 1980 · S/N 28-8011145N929TCMattern Daniel L · Howard, PABuilt 1973 · S/N 28-7310135N92AFGraben Dale · Collinsville, ALBuilt 1968 · S/N 28-11102N92CZBluebirdaero Inc · Magnolia, TXBuilt 1968 · S/N 28-25276N92DADelory Dana E · Shoreacres, TXBuilt 1992 · S/N 28-37057N92ECStevens Faustin R · Kennewick, WABuilt 1977 · S/N 32R-7880007N92EJSecond Life Properties LLC · Salisbury, MDBuilt 1978 · S/N 32R-7885242N92ETWeigel Andrew F · Elbow Lake, MNBuilt 1979 · S/N 28-7911215N92FBBauer Aviation LLC · St Germain, WIBuilt 1969 · S/N 28-5321N92GMPeri Joseph · Thorntown, INBuilt 1978 · S/N 28R-7803263N92GRMarrero Teresa · Jayuya, PRS/N 28-7816159N92HDN242ak LLC · Ocala, FLBuilt 2003 · S/N 3257326N92LLTanner Dave · Auburn, CABuilt 2000 · S/N 3257191N92UATaylor Aviation Inc · Montgomery, NYBuilt 1992 · S/N 2837058N9300JRoberts Raymond R · Independence, MOBuilt 1966 · S/N 28-3391N9300WGroman Steven R · Peoria, AZBuilt 1967 · S/N 28-10978N9301JN9301j LLC · Reno, NVBuilt 1966 · S/N 28-3392N9301NAnderson Robert · Tonopah, AZBuilt 1969 · S/N 28R-35001N9301WHansted Jon · Maineville, OHBuilt 1968 · S/N 28-10979N9302FBlue High Horizons LLC · Clayton, GAS/N 32R-7780123N9304WBark N Bite Aviators LLC · Sedona, AZBuilt 1967 · S/N 28-10983N9305KHitech Aerospace Corp · New York, NYBuilt 1976 · S/N 28-7625175N9305WKirby Rick D · Kimball, NEBuilt 1967 · S/N 28-10984N9306JHanna Jr Charles W · Kingstree, SCBuilt 1966 · S/N 28-3398N9307JWilliams Austen T · Fort Worth, TXBuilt 1966 · S/N 28-3399N9307WHedgers Thomas W · Lino Lakes, MNBuilt 1967 · S/N 28-10986N9308JYoung Ashley G · Lexington, NCBuilt 1966 · S/N 28-3400N9308WHubbard Manu L · Riverside, CABuilt 1967 · S/N 28-10987N9309KVera Rojas Guillermo A · Albuquerque, NMBuilt 1976 · S/N 28-7615194N930KGGriggs Roger · Columbia, SCS/N 32R-8029027N930MAPlaceway Scott M · Lapeer, MIBuilt 2020 · S/N 2881404N930RJN147sb LLC · Cortland, NYBuilt 1970 · S/N 28R-35754N930SSV1 Aviation Leasing LLC · Fairborn, OHS/N 32R-8113061N9310JBuckwalter Russell · Broadway, VABuilt 1966 · S/N 28-3403N9310NApproach Partners LLC · Franklinton, NCBuilt 1969 · S/N 28R-35010N9310WGb Aviation LLC · Alpine, CABuilt 1967 · S/N 28-10990N9311JSentelle Amanda L · Frederick, MDBuilt 1966 · S/N 28-3404N9311NAmendt Joseph J III · Plymouth, MNBuilt 1969 · S/N 28R-35011N9313CWright Terrence Richard · Tiffin, OHBuilt 1978 · S/N 28-7816459N9313JLockhart Michael B · Redlands, CABuilt 1966 · S/N 28-3406N9313KStauffer Donald R Jr · Tracy, CABuilt 1976 · S/N 28-7690241N9313WDjb Aviation LLC · Pompano Beach, FLBuilt 1967 · S/N 28-10993
Back to AD 87-08-08 R3