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.

N5242STanakon Inc · Fairbanks, AKBuilt 1970 · S/N 32-40930N5243LKeys Robert C · Winston Salem, NCBuilt 1967 · S/N 28-4538N5244LGarman Daniel L · Burr Oak, KSBuilt 1968 · S/N 28-4539N5245WSwartzfager Lee C · Corry, PABuilt 1962 · S/N 28-287N5246LSmithson Thomas E · Franklin, TNBuilt 1967 · S/N 28-4541N5246SPapa Kilo Aviation LLC · Palm Beach, FLBuilt 1970 · S/N 32-40950N5246WScovil Jarin K · Laramie, WYS/N 28-288N5247FBasha Joseph W Jr · Alexandria, LAS/N 32-7740002N5247TTevik Michael A · Provo, UTBuilt 1972 · S/N 28-7225371N5248TDopfel Sierra M · Udall, KSBuilt 1972 · S/N 28-7225372N5248WBalfa Joshua · Lumberton, TXBuilt 1962 · S/N 28-290N5249TTri-Angle Aviation LLC · Henderson, KYBuilt 1972 · S/N 28R-7235204N524CWCentral Washington University · Ellensburg, WABuilt 2017 · S/N 2843924N524FLMoore Bruce W · Aledo, TXBuilt 1971 · S/N 28-7125351N524JASkyhawk Leasing LLC · Indianapolis, INBuilt 2020 · S/N 28020002N524KCEmanon LLC · Apex, NCBuilt 2004 · S/N 3232030N524MFunny Penguin LLC · North Canton, OHBuilt 1969 · S/N 28R-31101N524PAm Utilities & Construction LLC · Palmhurst, TXBuilt 1969 · S/N 28R-35263N524PUMetro Aircraft Co · Bloomington, MNBuilt 1989 · S/N 2841189N524SCSpartan Education LLC · Tulsa, OKBuilt 2019 · S/N 2881265N5250LAcharya Jagat P · Powell Butte, ORS/N 28-4545N5250TMedlaw Aviation LLC · Temple, TXS/N 28R-7235206N5251LRegistration Pending · Osage Beach, MORegistration pendingBuilt 1967 · S/N 28-4547N5251SHegarty Joseph L · Sioux Falls, SDBuilt 1970 · S/N 32-40954N5252SFkf LLC · Imperial, NEBuilt 1970 · S/N 32-40934N5253THart William · Johnson City, TNS/N 28-7225373N5255QScott Michael S · Las Vegas, NVS/N 3257212N5255TGood Joseph A · Weymouth, MABuilt 1972 · S/N 28-7225375N5255WHoppes Curt · Saint Jacob, ILBuilt 1962 · S/N 28-299N5256LIngram Aviation LLC · Johns Island, SCBuilt 1967 · S/N 28-4553N5258SPace Aviation LLC · The Woodlands, TXBuilt 1970 · S/N 32-40955N5259LPennsylvania Flying Assoc Inc · Saegertown, PABuilt 1967 · S/N 28-4557N5259SSquier Robert J · Royal Oak, MIBuilt 1970 · S/N 32-40939N525FLSiebert Derrick R · Wausau, WIBuilt 1971 · S/N 28-7125357N525MGN525mg LLC · Menlo Park, CABuilt 1999 · S/N 3257118N525NJKrystal Ali · Fort Worth, TXS/N 28-7716173N525PULindsay Aviation Inc · West Seneca, NYS/N 28-8316102N525RJValiair Limited Company Trustee · Casper, WYBuilt 1977 · S/N 32R7780278N525VBLincoln Robert D · Bedminster, NJFirst renewal noticeBuilt 1978 · S/N 28R-7837287N5262LWilliams Gregory L · Tehachapi, CABuilt 1967 · S/N 28-4560N5262SSalls Robert A · Glen Mills, PABuilt 1971 · S/N 32-7140040N5262TSmith Gregory W · Laurel, MDBuilt 1972 · S/N 28R-7235210N5263LRjl Aero Inc · Valparaiso, INBuilt 1967 · S/N 28-4561N5263TBackroads Aviation LLC · Holdrege, NEBuilt 1972 · S/N 32-7240102N5264WGray Donald B Trustee · Houston, TXBuilt 1961 · S/N 28-310N5265SEagle Aeronautics LLC · Chicago, ILBuilt 1971 · S/N 32-7140044N5265WDwight Marketing Corporation · Caldwell, KSBuilt 1962 · S/N 28-311N5266SFogle Cooper · Mooresville, NCBuilt 1971 · S/N 28R-7135120N5267LBlasi Aviation LLC · Valley Center, KSBuilt 1967 · S/N 28-4565N5268TDykes Don A · Houston, TXBuilt 1972 · S/N 28-7205252
Back to AD 87-08-08 R3