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.

N6189ZHall William B · Vincentown, NJBuilt 1960 · S/N 25-223N618ARoberts Jeffrey M · Markleville, INBuilt 1975 · S/N AA5A-0006N618BDSandhu Sky Ventures LLC · Livermore, CABuilt 1989 · S/N 4622047N618BSBauer Thomas G · Sturgeon Bay, WIBuilt 2018 · S/N 7N618DCrockett Brandon A · Hollis Center, MEBuilt 2003 · S/N 001N618DVVance Donn D · Monterey, TNBuilt 2022 · S/N 618N618EMMoffitt Michael E · Kent, IABuilt 1971 · S/N 28-7205009N618FLDexter Development LLC · Kingfield, MEBuilt 1971 · S/N 28-7125503N618FTFlorida Institute Of Technology · Melbourne, FLBuilt 1985 · S/N 28-8516048N618JMaldonado Jose Ivan · Hahira, GABuilt 1992 · S/N RV-4-1569N618JKAiuto James J · Sterling Heights, MIBuilt 1994 · S/N 733-94N618JWMeriden Flyers LLC · Middlefield, CTBuilt 2008 · S/N 72746N618MNEack Kenneth B · White Rock, NMBuilt 1977 · S/N 172-69028N618NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881137N618RJDr Ghods Dmd Inc · Las Vegas, NVBuilt 2003 · S/N 90082N618RLLynn Robert W · Independence, WVBuilt 2021 · S/N 324N618SMHoyle Jason R · Grove, OKBuilt 1975 · S/N 61P-0201-016N618TMTuskegee Airmen National Historical Museum · Detroit, MIBuilt 1979 · S/N 17273346N618VMVan Eendenburg John · Bloomington, MNBuilt 2019 · S/N 892N61901Lalaguna Ricardo · Orlando, FLBuilt 1975 · S/N 17264880N6190DTap Solutions Inc · San Diego, CABuilt 1979 · S/N 17272623N6190JMiller James A · Fairbanks, AKBuilt 1976 · S/N 32R-7680329N6190RSundance Flying Club Inc · Palo Alto, CABuilt 1979 · S/N 172RG0110N6190UCox Paul G · Bryce, UTBuilt 1974 · S/N 31-7401232N6190WGrubenmann Ernst · Los Angeles, CABuilt 1964 · S/N 28-20217N61915Economy Flying Club Inc · Cusick, WABuilt 1975 · S/N 17264883N6191DBrookway Aviation LLC · Brookhaven, MSBuilt 1957 · S/N 18-5485N6191HFlying Inn Dfw LLC · Ft Worth, TXBuilt 2007 · S/N 40419N6191SSky King Aviation Services LLC · Lakeside, AZBuilt 1980 · S/N R18201647N6191WHarris Nathaniel T · Oronogo, MOBuilt 1964 · S/N 28-20219N6192Miller Kevin L · Arlington, WABuilt 1992 · S/N 0259N61921Sts Aviation LLC · Daytona Beach, FLBuilt 2000 · S/N TB4250N61922Chipman Roger M · Birch Harbor, MEBuilt 1975 · S/N 17264887N61923Northwoods Air LLC · Orono, MEBuilt 1975 · S/N 17264888N61925St Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1975 · S/N 17264890N61928Borszich Claude C · Phoenix, AZS/N 17264891N6192JFirst Flight Corp · San Diego, CABuilt 1976 · S/N 28-7625229N6192PLevin Sidney M · Buffalo Grove, ILBuilt 1959 · S/N 24-1294N61933Geebee Ventures LLC · Belgrade, MTBuilt 1975 · S/N 17264894N61936Huffman David A · Oklahoma City, OKBuilt 1975 · S/N 17264897N61937Simplifly LLC · Mesa, AZBuilt 1975 · S/N 17264898N6193PTurner William Neal · Idalou, TXBuilt 1959 · S/N 24-1295N6193YMatthews Aviation LLC · Hardinsburg, KYBuilt 1966 · S/N 27-3419N61943Phoenix Composite Solutions LLC · Oscoda, MIBuilt 1975 · S/N 17264903N61947Driggers Spencer A · Lake City, SCBuilt 1975 · S/N 17264906N6194DBha Leasing Corp · South Portland, MEBuilt 1979 · S/N 17272626N6194EReeburgh Scott L · Vancouver, WABuilt 1978 · S/N 17271998N6194JJettstar LLC · Marshall, MNBuilt 1976 · S/N 28-7690368N6194PCrosby Tire & Body Shop Inc · Crosby, NDBuilt 1959 · S/N 24-1296N61951Propability One LLC · Daytona Beach, FLBuilt 1975 · S/N 17264908
Back to AD 87-10-06 R1