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.

N7342JWingate Nicholaus · Lawton, OKS/N 28-24671N7343JSawyer Dean A · Kerrville, TXBuilt 1968 · S/N 28-24484N7343WRicht Jerry A · Cleveland, TNBuilt 1963 · S/N 28-1214N7344WRegistered aircraftBuilt 1963 · S/N 28-1221N7345JAlpha 1 Aviation LLC · Helena, ALBuilt 1968 · S/N 28-24612N7346JJacobson Daniel · Neenah, WIBuilt 1968 · S/N 28-24620N7347WHinzman Mark D · Reno, NVS/N 28-1224N7348JDippolito Mario M · Sherwood, ARBuilt 1968 · S/N 28-24698N7348WRosenau Dillon L · Upham, NDBuilt 1963 · S/N 28-1226N7349JWolfe Frank A · Nahcotta, WABuilt 1968 · S/N 28-24699N7349WGritzo Russell E · Edgewood, NMBuilt 1963 · S/N 28-1228N734TNConsolidated Aviation Services LLC · Seymour, TNBuilt 1977 · S/N 28R-7703230N734XMahler Steven · Hanover, PABuilt 1974 · S/N 28-7405079N7350WLisa Mark P · Paso Robles, CABuilt 1963 · S/N 28-1229N7351JRudolph Robert E · Martinez, CABuilt 1968 · S/N 28-24702N7351WMoser Jeffrey E · Creighton, NEBuilt 1963 · S/N 28-1230N7353WSales Michael · Delphi, INS/N 28-1233N7354J7354j LLC · Colorado Springs, COBuilt 1968 · S/N 28-24706N7354WAmico David A · Newburyport, MABuilt 1963 · S/N 28-1234N7355JCzyszczon Aviation LLC · St Pete Beach, FLBuilt 1968 · S/N 28-24707N7356JHyatt Philip D · Gadsden, ALBuilt 1968 · S/N 28-24708N7357JCswnz Inc · Wilmington, DEBuilt 1968 · S/N 28-24709N7359JAdams Daniel W · Maryville, TNBuilt 1968 · S/N 28-24711N7359WHumphrey Eric N · Osceola, IABuilt 1963 · S/N 28-1239N735FLInternational Air Services Inc Trustee · Carson City, NVS/N 28-7225537N7360WLudwig Paul P · Algonquin, ILBuilt 1963 · S/N 28-1240N7361WRichart Mark D · Canton, PABuilt 1963 · S/N 28-1358N7362WWinterberg Jeremy · Auburndale, FLBuilt 1963 · S/N 28-1242N7363WBurke David L · Sturgeon Bay, WIBuilt 1963 · S/N 28-1243N7364JLewis Mark A · Ozark, ALBuilt 1968 · S/N 28-24718N7365WRobert Jason T · Fernandina Beach, FLS/N 28-1246N7366WBatchelder Norman · Newport Beach, CAFirst renewal noticeBuilt 1963 · S/N 28-1248N7367JWise Dustin A · Fairbanks, AKS/N 28-24722N7367WRapp Stephen Martin Trustee · Zephyr, TXBuilt 1963 · S/N 28-1249N7368WBurkholder Earl F · Middleburg, PABuilt 1963 · S/N 28-1250N7369JSmith Zachary T · Nokesville, VABuilt 1968 · S/N 28-24724N736NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2018 · S/N 2881025N736RMBagwell Danny A · Arley, ALBuilt 1967 · S/N 28-22876N736XPsa LLC · Fort Myers, FLBuilt 1973 · S/N 32-7340095N7370JBoone Bradford D · Lincoln, MEBuilt 1968 · S/N 28-24725N7370WDonahue Emily Stacy · Dallas, TXBuilt 1963 · S/N 28-1252N7371WVista I Inc · Smithville, OHBuilt 1963 · S/N 28-1253N7372JMccabe Colin · Frisco, TXBuilt 1968 · S/N 28-24727N7373WColvin Michael E · Monroe, WIBuilt 1963 · S/N 28-1255N7375CErick Enterprises LLC · Spreckels, CABuilt 1969 · S/N 28-25634N7375JRegistered aircraftBuilt 1968 · S/N 28-24731N7375WSims Phillip · Titusville, FLS/N 28-1257N7376WButtercup Express LLC · Woodward, OKBuilt 1963 · S/N 28-1278N7377JKlinginsmith Randal L · Kearney, NEBuilt 1968 · S/N 28-24740N7377WMorris Vaughan · Weatherford, TXBuilt 1963 · S/N 28-1259
Back to AD 87-08-08 R3