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.

N8962NGallen Peter · Wilmington, DEBuilt 1969 · S/N 32-40773N8962PDunning John · Stow, MABuilt 1966 · S/N 24-4419N8962YChoate Cass Joseph · Toone, TNS/N 39-122N8963DDoyle Patrick H · Keller, TXBuilt 1958 · S/N 22-6127N8963NBaker Daniel T · Jackson, OHBuilt 1969 · S/N 32-40774N8963YNess Rent A Car Inc · Fargo, NDS/N 39-123N8964DThomas Daniel C · Shady Shores, TXBuilt 1958 · S/N 22-6128N8964JKemper Kevin K · Granite Bay, CABuilt 1992 · S/N 028N8964PPerkins Michael W · Warren, MIBuilt 1966 · S/N 24-4421N8964VOneill Jared · Gilroy, CABuilt 1974 · S/N 17264320N8964W3720 To 1 Inc · Greenwood Village, COBuilt 1964 · S/N 28-10540N8965DSale Reported · Beech Creek, PASale reportedBuilt 1958 · S/N 22-6129N8965JN8965j LLC · Anchorage, AKBuilt 1966 · S/N 28-2987N8965LWeber Daniel M · Oconomowoc, WIBuilt 1974 · S/N AA1B-0415N8965PChancellor Richard · Palmer Lake, COBuilt 1966 · S/N 24-4422N8965WWarlick Bradley Q · Negaunee, MIBuilt 1964 · S/N 28-10541N8965YLucid Thought Consulting LLC · Terre Haute, INS/N 39-127N8966DDodd Robert L · Humboldt, IABuilt 1958 · S/N 22-6130N8966JBrown Bradford K · Leoti, KSBuilt 1965 · S/N 28-2988N8966NCherokee Six LLC · Minburn, IABuilt 1969 · S/N 32-40776N8966PLautensack Peter · Oswego, NYBuilt 1966 · S/N 24-4423N8966VCreider Paul E · Tulsa, OKBuilt 1974 · S/N 17264322N8967JJust Plane Fun LLC · Sunrise, FLBuilt 1965 · S/N 28-2990N8967TKellys Flying Service LLC · Warrensburg, MOBuilt 1981 · S/N 28-8190209N8967YQualitair LLC Trustee · MichelstadtBuilt 1971 · S/N 39-130N8968DCleary Katherine E · Mulberry, FLBuilt 1958 · S/N 22-6132N8968JStevens Raymond W · Norfolk, VAS/N 28-2991N8968QSonnichsen Landen D · Delta Junction, AKBuilt 2021 · S/N 5802N8968VLittle Gordon D · Watertown, SDS/N 17264324N8968WRc Skywagon LLC · Miami, FLBuilt 1964 · S/N 28-10545N8969CStrahl Guenter H · Jackson, NJBuilt 1976 · S/N 28-7690173N8969NMatanane Roke C · Barrigada, GUBuilt 1970 · S/N 32-40769N8969VCrowley Brett A · Wasilla, AKS/N 17264325N8969WPostage Robert · Chapel Hill, NCBuilt 1964 · S/N 28-10546N8969YTrident Aero Services LLC · Park City, UTBuilt 1971 · S/N 39-132N896ACAri Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881414N896AKQuadcub Utah LLC · Salt Lake City, UTS/N 1N896ASSilverstein Adam R · Pittstown, NJBuilt 2007 · S/N 82089N896B49 Holdings LLC · Cheyenne, WYBuilt 2021 · S/N MB27N896BCClute William A · Simpsonville, SCBuilt 2011 · S/N 001N896CFMiles Air Leasing LLC · Canonsburg, PABuilt 1968 · S/N 28-4852N896DFVenture North Aviation LLC · Cloquet, MNBuilt 2024 · S/N 2881696N896DLLane David A · Yuba City, CABuilt 2006 · S/N 80896N896JUniversity Of North Dakota · Grand Forks, NDBuilt 2022 · S/N 30086N896SCHansen Ernest F · Sequim, WABuilt 2020 · S/N 001N896SJTumbleweed Aviation LLC · Great Bend, KSBuilt 1996 · S/N 46-36033N8970JAll Tech Machine & Tool Inc · Greenwood, ARBuilt 1965 · S/N 28-2993N8970PPodraza Kevin M · Dekalb, ILBuilt 1966 · S/N 24-4427N8970VWinding Creek Aviation LLC · Snellville, GABuilt 1974 · S/N 17264326N8970WYoungblood Wade · Corsicana, TXBuilt 1964 · S/N 28-10548
Back to AD 87-10-06 R1