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.

N3659RInternational Air Services Inc Trustee · Carson City, NVBuilt 1970 · S/N 28-5762N365MKNorth Star Aviation Inc · Mankato, MNBuilt 2023 · S/N 2881688N365NGReid Michael V · Sulphur Springs, TXBuilt 1968 · S/N 28-11124N36601Frett Dennis R · Windsor, MOBuilt 1978 · S/N 28-7816671N36602B2 W Corporation · Winona, MNBuilt 1978 · S/N 28-7816672N36603J&J Holdings Of Pella LLC · Pella, IABuilt 1978 · S/N 28-7816673N3660RBackcountry Wings LLC · Gig Harbor, WABuilt 1970 · S/N 28-5764N36615Booth Warren Russell · Doylestown, PABuilt 1978 · S/N 32-7840166N36619Gipson Ronnie R · Carlisle, PABuilt 1978 · S/N 28R-7837286N3661MAlpha Kilo Enterprises LLC · Helena, MTBuilt 1978 · S/N 28R-7837129N3661WPrete Vincent A · Jim Thorpe, PABuilt 1966 · S/N 32-568N3662RBevard Thomas E · Montross, VABuilt 1969 · S/N 28-5766N3664MEchtle Keith A · Castroville, TXBuilt 1978 · S/N 28R-7803184N3664WSuffoletto Gregory · Hamburg, NYBuilt 1966 · S/N 32-572N3665WWitham Chris · Cathedral City, CABuilt 1966 · S/N 32-573N3667RShamrock Aviation LLC · Broken Bow, NEBuilt 1970 · S/N 28-5771N3668KPiston Aviation LLC · Saint Charles, MOBuilt 1967 · S/N 28-23678N36693Falcon Air LLC · Casper, WYBuilt 1978 · S/N 32R-7887065N3669RFulks Helicopter Service LLC · Norfolk, NEBuilt 1970 · S/N 28-5772N3669WDocken Marvin O · Omaha, NEBuilt 1966 · S/N 32-578N366CACavorite Aviation LLC · Lehi, UTBuilt 1998 · S/N 2843135N366LCLane Community College · Eugene, ORBuilt 1981 · S/N 28R-8218005N366MKNorth Star Aviation Inc · Mankato, MNBuilt 2023 · S/N 2881689N36700Archuleta Jeffrey Michael · Abilene, TXBuilt 1978 · S/N 28-7890526N3670RPecht Brian J · Lewistown, PABuilt 1969 · S/N 28-5773N36711N36711 Piper LLC · Provo, UTS/N 28-7890527N36716Smith Todd Andrew · Princeton, WVBuilt 1978 · S/N 32R-7887068N3671RRoberts Charlie E · Cleveland, GABuilt 1969 · S/N 28-5774N3671WOdean Steve · Palmer, AKS/N 32-580N3672KEgbert Colton T · Fernley, NVFirst renewal noticeBuilt 1967 · S/N 28-23682N36730Jones Kevin B · Mineral Wells, TXBuilt 1978 · S/N 32R-7885206N36733Speedz Enterprizes LLC · Hannibal, MOBuilt 1978 · S/N 32R-7887072N3673MBeacon Park Pointe LLC · Orlando, FLBuilt 1978 · S/N 32-7840069N36749Air Smt LLC · Powell, OHBuilt 1978 · S/N 28R-7837291N3675WWilson Ag Consulting LLC · Boise, IDBuilt 1966 · S/N 32-584N3676RRaider Aviation LLC · Lubbock, TXBuilt 1969 · S/N 28-5779N36777Litwin Linda J · Potomac, MDBuilt 1978 · S/N 28R-7837292N3677WGriffith Chad Wayne · Crosby, TXBuilt 1966 · S/N 32-586N36781Addison Thomas P · Haines City, FLBuilt 1978 · S/N 32R-7885208N36789Paschke Jay · Weatherford, TXBuilt 1978 · S/N 28-7890530N3678MCometair LLC · Greensboro, NCBuilt 1978 · S/N 32-7840070N3678WDiamond B Farm Inc · Gamaliel, KYFirst renewal noticeBuilt 1966 · S/N 32-587N367HRArrow Flight LLC · Baton Rouge, LABuilt 2000 · S/N 3257173N367LRLa Rotta Tony · Pembroke Pines, FLBuilt 1972 · S/N 28-7325044N367MKNorth Star Aviation Inc · Mankato, MNBuilt 2024 · S/N 2881746N36800Fly Aviation Corp · Wilmington, DEBuilt 1978 · S/N 28-7816658N36802United States Air Force- Owner · Hanscom Afb, MABuilt 1978 · S/N 28R-7837293N36804Poplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1978 · S/N 28R-7837295N36808Godwin Frederick H · Charlotte, TNBuilt 1978 · S/N 32R-7887084N3680WBeachy Titus E · Altamont, TNBuilt 1966 · S/N 32-590
Back to AD 87-08-08 R3