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.

N6235JFrost Aviation Services Inc · Las Cruces, NMBuilt 1976 · S/N 28-7615341N6236CAviation Equipment Company LLC · Leesburg, VABuilt 1978 · S/N 28R-7837151N6236JArcher N6236j LLC · Denver, COBuilt 1976 · S/N 28-7690377N6236WBjornstad John · Maple Grove, MNS/N 28-20278N6237JHulett Michael · Saginaw, MOBuilt 1976 · S/N 28-7690378N6238JDanish Air LLC · Wahpeton, NDBuilt 1976 · S/N 28R-7635324N6238WBurns Benjamin · Rockport, TXBuilt 1964 · S/N 28-20280N6239Arsenault Keith · West Brookfield, MABuilt 1984 · S/N 28-8590003N6239JBlack Diamond Aviation LLC · Cullman, ALBuilt 1976 · S/N 28R-7635325N623CCHotzler Terry A · Jackson, MNBuilt 1976 · S/N 28-7610098N623FTFlorida Institute Of Technology · Melbourne, FLBuilt 1977 · S/N 28-7816131N623WCWilkinson Craig R · Parker, AZS/N 28R-7931203N623WJAir Mods And Repair · Robbinsville, NJBuilt 1974 · S/N 28R-7435109N6240CN8116j Inc · Greenville, NCS/N 32R-7885022N6240HLouisa Air LLC · Louisa, VAS/N 28-7890220N6241WKnutson Wayne R · Thompson, NDFirst renewal noticeBuilt 1964 · S/N 28-20284N6242CFlight School 101 LLC · Winter Haven, FLBuilt 1978 · S/N 28-7816399N6242JEast Coast Autoline LLC · Whitehall, PAS/N 28-7625234N6242WPettie Randall D · Baltimore, MDBuilt 1964 · S/N 28-20239N6244JReid Michael · Morgan Hill, CABuilt 1976 · S/N 28-7615343N6244WTaylors Turf Paradise LLC · Whitewater, WIBuilt 1964 · S/N 28-20288N6247JInternational Air Services Inc Trustee · Carson City, NVS/N 28-7690380N6248CFort Leavenworth Flying Club · Fort Leavenworth, KSS/N 28-7816629N6249JAkwari Aerospace LLC · Burbank, CABuilt 1976 · S/N 32R-7680340N6249WWall Scott R · Franksville, WIBuilt 1964 · S/N 28-20295N624AQHigh Flight Academy LLC · Allison Park, PABuilt 1984 · S/N 28-8416122N624CJJones Steven Clark · Flagler Beach, FLBuilt 2020 · S/N 2881427N624CWSkypeck John · Nevada City, CABuilt 1980 · S/N 32-8006022N624DPHamons Spencer · Cookson, OKBuilt 1981 · S/N 32-8124033N624FTFlorida Institute Of Technology · Melbourne, FLBuilt 1979 · S/N 28-7916446N624GTTrue Lumen Aviation LLC · Grosse Pt Shr, MIBuilt 1978 · S/N 32R-7987041N6250CShields Ray Winfrey III · Marietta, GAS/N 28-7890357N6250WCummings Property Restoration LLC · Bullard, TXBuilt 1964 · S/N 28-20296N6251JGamache Bernard J · Yakima, WABuilt 1976 · S/N 28-7615345N6252WBas Part Sales LLC · Greeley, COBuilt 1964 · S/N 28-20299N6254JCoast Flight Training And Management Inc · San Diego, CABuilt 1976 · S/N 28-7690383N6254WHayes George L · Longmont, COBuilt 1964 · S/N 28-20302N6255WCrumpler Stephen M Jr · Smithfield, NCBuilt 1964 · S/N 28-20303N6256CKing David M · Plainville, CTBuilt 1978 · S/N 28R-7837154N6259WVision Of Flight Inc · Orlando, FLBuilt 1964 · S/N 28-20308N625BBBig Bend Community College · Moses Lake, WABuilt 2023 · S/N 2881694N625BGN625bg LLC · North Muskegon, MIBuilt 1979 · S/N 28-8011005N625FLFly Foxtrot Lima LLC · Philadelphia, PABuilt 1971 · S/N 28-7125514N625FTFlorida Institute Of Technology · Melbourne, FLBuilt 2001 · S/N 2842130N625NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 2881161N625PBForward Aviation LLC · Statesville, NCBuilt 1965 · S/N 32-271N625RSIndiana State University · Terre Haute, INBuilt 1979 · S/N 28R-7918253N625RWRomeo Whiskey LLC · Lake Havasu City, AZBuilt 1982 · S/N 32-8206024N6261WStar 1 LLC · Canyon Country, CAS/N 28-20310N6262BDrj Plane LLC · Hastings, NEBuilt 1981 · S/N 32R-8113067
Back to AD 87-08-08 R3