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.

N9175JSommer Eric M · London, OHBuilt 1966 · S/N 28-3241N9175SMarshall Adam A · Fremont, NEBuilt 1967 · S/N 24-4664N9175WHamilton Lee A · Franklin, INBuilt 1966 · S/N 28-10830N9176Elias Bernard J · Hampton, GABuilt 1970 · S/N 28PN9176DSmaha Daniel B · Glide, ORBuilt 1958 · S/N 22-6233N9176ETyrrells Trails LLC · Fairbanks, AKBuilt 1977 · S/N 7127CN9176GQs Aviation LLC · Laredo, TXS/N 4622055N9176HSky Walker Flight School LLC · Adrian, MIBuilt 1975 · S/N 17265993N9176JPayson Aero Club LLC · Payson, AZBuilt 1966 · S/N 28-3242N9176NWjr Aviation Inc · Caledonia, MIBuilt 1989 · S/N 3213025N9176PWalter Richard · Hampshire, ILBuilt 1967 · S/N 24-4665N9177Chaffin Christopher · Flower Mound, TXBuilt 1972 · S/N 3125N9177DCheyann Jordan · Coupeville, WABuilt 1958 · S/N 22-6234N9177EBell Joseph · Lakewood, CABuilt 1977 · S/N 7125CN9177HLind Enterprises LLC · Manistee, MIBuilt 1976 · S/N 17265994N9177PCochran Charles M III · Terre Haute, INBuilt 1967 · S/N 24-4666N9177SNabeth Jeremy S · Austin, TXBuilt 1976 · S/N M-1789N9177WBartels Gary A · Daykin, NEBuilt 1966 · S/N 28-10833N9178CKelly Randall Shawn · Rocklin, CABuilt 1978 · S/N R18200437N9178LClarke Paul W · Cape Girardeau, MOBuilt 1972 · S/N 5-72N9178PCarnes Harley · Ocean, NJBuilt 1967 · S/N 24-4668N9178QMartinez Manuel G · Downers Grove, ILBuilt 1976 · S/N 20-1197N9178SSwoboda Kristin · Boise, IDBuilt 1976 · S/N MC-406N9178VWingman Aviation Partners LLC · Wentzville, MOBuilt 1969 · S/N 690017N9178WBoyd Dean W · Merrill, WIBuilt 1966 · S/N 28-10834N91793Oexmann James Bennett · Lexington, KYS/N 17261514N9179EFrisco Flyers LLC · Macedonia, ILBuilt 1977 · S/N 7128CN9179HMeteiver Lawrence J · Elkhart, INBuilt 1975 · S/N 17265995N9179SCharles Clarens · Brooklyn, NYBuilt 1976 · S/N M-1800N9179VVinter Mooney LLC · Philadelphia, PAS/N 690035N9179WVangura David · Ponte Vedra Beach, FLBuilt 1966 · S/N 28-10835N917CFN917cf LLC · Tucson, AZBuilt 2005 · S/N T20608523N917CMKaraszewski Michael J · Pensacola, FLBuilt 2022 · S/N 41171N917DKEncore Jet Management LLC · San Antonio, TXBuilt 1998 · S/N 2843186N917FAAlpha Aircraft International LLC · Lake Worth, FLBuilt 1980 · S/N 17274062N917GDAir Charter Inc DBA · Culebra, PRBuilt 1976 · S/N 789N917GKAmdel Holding LLC · Houston, TXBuilt 1978 · S/N 17271567N917GTCentral Airlines Inc · Leawood, KSBuilt 1960 · S/N 500B-983-24N917KDRegistered aircraftBuilt 1976 · S/N AA5A0156N917MAKs Flying Club Inc · Manhattan, KSBuilt 1999 · S/N 172S8270N917MBRegistration Pending · Ravenel, SCRegistration pendingBuilt 2021 · S/N 0001N917PFBrown Charles James · Littlefield, TXBuilt 1995 · S/N 21339N917SELarson Donald C · Evanston, WYBuilt 1989 · S/N 27-0048N917TCDebarros David · Ashland, VABuilt 1998 · S/N 2843167N917VKNorthern Lights Ventures LLC · Moose Pass, AKBuilt 1974 · S/N 18-7409056N917WETaylor William H II · Albuquerque, NMBuilt 1968 · S/N 17256920N917WSRv Time LLC · Cape Coral, FLBuilt 2000 · S/N 21657N917WTStamsta David T · Ennis, MTBuilt 2003 · S/N 00-1170N917XKirkegaard Lewis J · Grand Junction, COBuilt 2012 · S/N 7375N917ZWRealmark Ovation Rv10 LLC · Cape Coral, FLBuilt 2010 · S/N 40616
Back to AD 87-10-06 R1