AD 87-10-06 R1

Registered aircraft · 72,010

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-10-06-R1')
    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-10-06-R1')
  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.

N6908UPaul Michael · Fort Worth, TXBuilt 1964 · S/N 2703N6908VForoozesh Paymon Michael · Olalla, WABuilt 1975 · S/N 20-1178N6909BKaufmann Arnold L · Davenport, IABuilt 1956 · S/N 22-4184N6909NDevore John A C · Marion, OHS/N 680174N6909PWest Texas Weather Modification Association · San Angelo, TXBuilt 1960 · S/N 24-2043N6909QHuston Lee E · Graham, WABuilt 1967 · S/N MB-281N6909UVandivort Austin J · Strawberry Plains, TNS/N 2704N690ABKirkland Klayton E · College Station, TXS/N B-001N690BLincwings Society LLC · Austin, TXBuilt 1955 · S/N 23-382N690HAAims Community College · Greeley, COBuilt 2025 · S/N 2881865N690JTAviationmt LLC · Kalispell, MTS/N 28-7205042N690LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881196N690PMMiddlefield Farm And Garden Co · Middlefield, OHBuilt 2024 · S/N 2881728N690RGRegistration Pending · Gurabo, PRRegistration pendingBuilt 1969 · S/N 274260N690RRCentral Airlines Inc · Leawood, KSBuilt 1962 · S/N 500B-1169-88N690SHCorriher Mark B · Mocksville, NCBuilt 1966 · S/N 132N690VBruegger Traylin T · Lance Creek, WYBuilt 1990 · S/N 20051N690ZKalisz John B · Newhall, CABuilt 1992 · S/N 2029N6910DWood Robert A · Sheboygan, WIBuilt 1957 · S/N 22-4837N6910JPlane Nonsense Inc · Middletown, DEBuilt 1976 · S/N 28-7615395N6910NThornton Michael W · Clinton, NCBuilt 1968 · S/N 680137N6910PBlue Skies Aviation LLC · Algona, IABuilt 1985 · S/N 28-8511008N6910UEmbrey Quentin S · Beaver Dam, KYBuilt 1964 · S/N 242N6910VLehman Aubrey M · Temple, TXS/N 22-1290N6911HHarbour Aviation LLC · Weatherford, TXBuilt 1975 · S/N 17265639N6911JJacksonville Airport Authority · Jacksonville, ILBuilt 1976 · S/N 28-7615396N6911PMalo Blake Ridgway Trustee · Portland, ORBuilt 1985 · S/N 28-8590050N6911QKirby Richard L Trustee · Albuquerque, NMBuilt 1985 · S/N 28-8511009N6911YDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1969 · S/N 27-4266N6912JHammond Brian M · Gresham, ORBuilt 1976 · S/N 28-7690427N6912PAnzaldua Johnny J · Midland, TXFirst renewal noticeBuilt 1960 · S/N 24-2046N6912WTop Flight Aviation Snh LLC · Savannah, TNBuilt 1965 · S/N 28-21287N6913ANorthwoods Air LLC · Orono, MEBuilt 1979 · S/N 27-7954108N6913BKeyt Jeffrey D · New Providence, NJBuilt 1956 · S/N 22-4188N6913JFlight Time LLC · Conover, NCBuilt 1976 · S/N 28-7690428N6913NJennings William A · North Little Rock, ARBuilt 1968 · S/N 680138N6913RAirplane And Drone Flight Instruction LLC · Orlando, FLBuilt 1985 · S/N 28-8590054N6913SRural Development Corp 1 · Steamboat, COBuilt 1985 · S/N 28-8511010N6913UShaw Brian D · Meadville, PABuilt 1964 · S/N 245N6913WAden James D · Gothenburg, NEBuilt 1965 · S/N 28-21288N6914AFlyn 6914 Alpha LLC · Oak Island, NCBuilt 1985 · S/N 28-8511011N6914BLark Bradley J · Enoch, UTBuilt 1956 · S/N 22-4189N6914JKreppel Frederick W · Wayne, PABuilt 1976 · S/N 28-7690429N6914ULiskey John W · Kelseyville, CABuilt 1964 · S/N 246N6914VDuke Terri D · Oakwood, GABuilt 1975 · S/N 22-1294N6914WPearson Timothy M · Waterville, OHBuilt 1965 · S/N 28-21084N6915H2gbs LLC · Wilder, IDBuilt 1975 · S/N 17265640N6915NBaker Stewart D · Severna Park, MDBuilt 1968 · S/N 680139N6915QWilson Kenneth G · Peoria, AZS/N MB-278N6915TSpier Samuel · Carson City, NVBuilt 1985 · S/N 28-8590058
Back to AD 87-10-06 R1