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.

N8863WPratt William D · Cashmere, WAS/N 28-10418N8864DMarsteller Paul A · Tallulah Falls, GABuilt 1958 · S/N 22-6038N8864VAnthony Baruth · Saint Joseph, MOBuilt 1971 · S/N 32-48N8864YMiller Donald W · Harrisonburg, VABuilt 1970 · S/N 39-19N8865PBrown Travis E · Leicester, NCBuilt 1965 · S/N 24-4322N8866FReynolds Darryl G · Wills Point, TXBuilt 1969 · S/N 0242N8866NYu Hermon Lemuel C · Mays Landing, NJBuilt 1969 · S/N 28-26251N8866WPalmer Todd J · Sherrills Ford, NCBuilt 1964 · S/N 28-10421N8866YCarson Ryan P · Albuquerque, NMBuilt 1971 · S/N 28-7125339N8867NMulloy Dennis · Indian Mound, TNBuilt 1969 · S/N 28-25729N8867PAnderson Keith C · Puyallup, WABuilt 1970 · S/N 18-8867N8867WPayne Jason S · Overgaard, AZBuilt 1964 · S/N 28-10422N8867YPiper Thirty Nine LLC · Glasgow, MTBuilt 1970 · S/N 39-22N8868JGannon Robert M · Hamburg, NYBuilt 1968 · S/N 28-24354N8868PBurrough Haus Properties LLC · San Marcos, TXBuilt 1965 · S/N 24-4325N8868VWard Steven E · Wilbur, WABuilt 1972 · S/N 32-62N8868WBolton Barbara A · Alameda, CABuilt 1964 · S/N 28-10424N8869JRoot Roger T · Moscow, IDBuilt 1965 · S/N 28-2841N8869NCarland Ralph B · Altoona, PABuilt 1969 · S/N 28-25731N8869WA&O Properties LLC · Harlan, IAS/N 28-10425N8869YCome Fly Away LLC · Waterloo, ILBuilt 1970 · S/N 39-24N886ACAir Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881397N886ATDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496323N886BNairn Bryan D · Edgewood, WABuilt 2001 · S/N 21963N886ECUp And Up Aviation LLC · Magnolia, TXBuilt 1977 · S/N 28-7816262N886JBRegistered aircraftS/N 30058N886JHJpj Aviation Holdings LLC · Wilmington, DEBuilt 1981 · S/N 32R-8213006N886PBarrons Aviation Services LLC · Henderson, NVBuilt 1962 · S/N 2328N886RASmith Daryl N · Coventry, CTBuilt 1959 · S/N 22-6944N886RVBazazan Mehrdad D · Fredericksburg, VABuilt 1994 · S/N 21707N886SACumbass David Shane · Douglas, GABuilt 2000 · S/N 0004N886SBWhitney Matt Gene · Watertown, SDBuilt 2026 · S/N 92 MN886THMock Joseph R · Huntsville, TXBuilt 1974 · S/N 142-74N886TVNault Thomas R · Mojave, CABuilt 2021 · S/N 001N886ZJohn Galt LLC · Fairbanks, AKBuilt 2022 · S/N 4135CN8870DHaumschild Edward E · Marana, AZBuilt 1958 · S/N 22-6044N8870EGriffin Robert B · Middletown, DEBuilt 1976 · S/N 28-7610089N8870JAsel LLC · North Charleston, SCS/N 28-2842N8870NRiley Dennis M · Surry, MEBuilt 1969 · S/N 28-25732N8870VOklahoma Historical Steam Engine Museum Foundation · Oklahoma City, OKS/N 32-52N8871DSmith James A · Lyle, WABuilt 1958 · S/N 22-6045N8871FGarvey Michael · Leesville, SCBuilt 1963 · S/N 0235N8871JJohnson Richard E · Mulberry, FLBuilt 1965 · S/N 28-2843N8871NCramer Michael L · Rockville Centre, NYBuilt 1969 · S/N 28-25733N8871PMq Flights LLC · Missoula, MTBuilt 1965 · S/N 24-4328N8871WGutierrez Alajandro · Madison, MSBuilt 1964 · S/N 28-10428N8872DJohnson Robert M · Ada, MNBuilt 1958 · S/N 22-6046N8872FCameron William Douglas Jr · Lexington, VAS/N 63-0238N8872GN8872g Holdings LLC · Nashville, TNBuilt 1966 · S/N 15062972N8872JPriority Aviation LLC · Lewes, DES/N 28-2844
Back to AD 87-10-06 R1