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.

N9610BGoodman Aviation LLC · Choteau, MTBuilt 1990 · S/N 1169N9610CHageman Theron · Jay Em, WYBuilt 1991 · S/N 1171N9610DHicks Joseph O · Germanton, NCBuilt 1958 · S/N 22-6520N9610QUS Aviation Group LLC · Denton, TXBuilt 1976 · S/N 17265695N9610RReynolds Kirk S · Skaneateles, NYBuilt 1959 · S/N TD-305N9610UMaschek Anthony Q · Harker Heights, TXBuilt 1975 · S/N AA5-0810N9611CSamrat Prithviraj Inc · Miami, FLBuilt 1997 · S/N 1N9611JStull Donald K · Catawba, NCBuilt 1966 · S/N 28-3761N9611MElectron Neutrino Inc · Lewes, DEBuilt 1966 · S/N 670188N9611UKingsley Paul A II · Idledale, COBuilt 1975 · S/N AA5-0811N9612DSoto Edward · Wasilla, AKBuilt 1958 · S/N 22-6522N9612HRegistration Pending · Ocean Isle Beach, NCRegistration pendingBuilt 1975 · S/N 17266263N9612JReich Gregory N · Schwenksville, PABuilt 1966 · S/N 28-3810N9612UElizabeth B Hawley · Wichita Falls, TXBuilt 1975 · S/N AA5-0812N9612VLe Roux Rocco · Carlsbad, CABuilt 1971 · S/N 21-0018N9612WJama Aviation LLC · Blaine, MNBuilt 1967 · S/N 28-23066N9613HFiedler Mark · Wichita, KSBuilt 1975 · S/N 17266264N9613JKraun Fred M · Fall City, WABuilt 1966 · S/N 28-3766N9613MLeland Erik J · Beaverton, ORS/N 670190N9613UGlenn Thomas Joel Hr · Fort White, FLS/N AA5-0813N9613WAir Wilma LLC · Tijeras, NMS/N 28-23067N9614Grohsmeyer Steven P · Franklin, KYBuilt 2008 · S/N 5N9614CBravo Foxtrot Zulu Holdings LLC · Unionville, CTBuilt 1978 · S/N 32-7840106N9614EWeber William J · Durham, NCBuilt 1991 · S/N 1179N9614HC&H Elite Air LLC · Johnstown, COBuilt 1975 · S/N 17266265N9614JSkinner Roger · Delanson, NYBuilt 1966 · S/N 28-3767N9614MSmith Michael O · Conroe, TXBuilt 1966 · S/N 670191N9614QConrad Terry E · Lancaster, OHBuilt 1975 · S/N 17265699N9614SFlatonia Veterinary Clinic Inc · Flatonia, TXBuilt 1966 · S/N 46N9614WByrne Matthew A · West Allis, WIBuilt 1967 · S/N 28-23069N9615CD Wayne Hollar Jr Dds Pa · Lenoir, NCBuilt 1978 · S/N 32-7840107N9615DPeterson Thomas M · Park Rapids, MNBuilt 1959 · S/N 22-6525N9615MMorgan Mark · Durango, COBuilt 1966 · S/N 670192N9615RAlbright Frank · Elba, ALBuilt 1991 · S/N 1185N9615UKnutson Duane G · Brookings, SDBuilt 1975 · S/N AA5-0815N9615ZTampa Bay Soaring Society Inc · Zephyrhills, FLBuilt 1963 · S/N 1018N9616ABoyd Ronald J · Genoa, COBuilt 1990 · S/N 1170N9616JGarsteck Paula · Put In Bay, OHBuilt 1966 · S/N 28-3769N9616LMid Island Air Service Inc · Ronkonkoma, NYBuilt 1986 · S/N 17276590N9616MBohn Aaron L · Valdosta, GAS/N 670193N9616QClearview Flying Club Inc · Westminster, MDBuilt 1975 · S/N 17265701N9616RPray Aviation Inc · Augusta, KSS/N TD-295N9616WKohut Jeanette G · Southern Pines, NCBuilt 1967 · S/N 28-23071N96177B2 Cpr Plus Inc · Bermuda Dunes, CABuilt 1970 · S/N 17701543N9617CPete And Pete Sales Inc · Williamsville, NYBuilt 1978 · S/N 32R-7885060N9617DWinton Christopher M · Valley Center, KSBuilt 1958 · S/N 22-6528N9617HShinn Lake D · Stevensville, MTBuilt 1976 · S/N 17266267N9617JBeaverdam Aeronautics LLC · Chatom, ALBuilt 1966 · S/N 28-3771N9617MSlusser Dennis G · Biggs, CAFirst renewal noticeBuilt 1966 · S/N 670194N9617QKagin Corp · Wilmington, DEBuilt 1975 · S/N 17265702
Back to AD 87-10-06 R1