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.

N63SASky View Aviation LLC · Lenoir, NCBuilt 1973 · S/N 17261610N63SMMoore George L · Spring Hill, KSBuilt 1986 · S/N 63N63SPGraves Klaric Carl · Fate, TXBuilt 2020 · S/N 41898N63TBSievers James E · Verdi, NVBuilt 1985 · S/N 504N63TXKilly James · Littleton, COBuilt 1991 · S/N 20360N63VLPulsar Investments Inc · Scottsdale, AZBuilt 2008 · S/N 91258N63WALariscey Adam · Lyons, GABuilt 2002 · S/N 001N63WFThompson Kevin J · Three Rivers, CAS/N 1136N63WMSmith Russell M · Bokeelia, FLBuilt 1996 · S/N 114N63WPRenno Aero LLC · Ann Arbor, MIBuilt 2005 · S/N 40.498N63WTRodencal Richard · Wisconsin Rapids, WIBuilt 1998 · S/N 404-98N64001Alpha One Aviation LLC · Corona, NYBuilt 1975 · S/N 17264949N64007Baugh Tommye R · Star City, ARBuilt 1975 · S/N 17264955N6400PRiegel Frederick E · Houston, OHBuilt 1959 · S/N 24-1510N6400SRegistration Pending · Salida, CORegistration pendingBuilt 1999 · S/N 4272/218N6400UAudetat Thomas Jr · Marana, AZBuilt 1962 · S/N 2147N6400VFearon Kenneth M · Sidney, OHBuilt 1980 · S/N 172RG0662N6400WRegistration Pending · Los Osos, CARegistration pendingBuilt 1964 · S/N 28-20468N6400YAztec Flyers LLC · Zephyrhills, FLBuilt 1967 · S/N 27-3685N64012Jin Jin Aviation LLC · Anchorage, AKBuilt 1981 · S/N 17275505N64014Maynor Robert B · Mansfield, LABuilt 1975 · S/N 17264961N64016Ponderosa Aviators LLC · Baker, MTBuilt 1975 · S/N 17264963N64017Pilots Today Inc · Berlin, MDBuilt 1975 · S/N 17264964N6401JMccarthy J Patrick · Pleasanton, CABuilt 1968 · S/N 28-4817N6401QHunter Donald J · Scottsdale, AZBuilt 1967 · S/N 670141N6401RNorthern Prairie Sky LLC · Erskine, MNBuilt 1966 · S/N 28-21579N6401UBlue Sky Aviation Adventures LLC · St George, UTS/N 2148N6401VGdl Aviation LLC · Lincoln, NEBuilt 1980 · S/N 172RG0663N6401YBudd Richard E · Brooksville, FLBuilt 1967 · S/N 27-3686N64020Bend Aircraft Mechanics LLC · Bend, ORBuilt 1975 · S/N 17264966N64023Rawson Aviation LLC · Collinsville, OKBuilt 1975 · S/N 17264969N64027Snyder Brent R · Dallas, TXBuilt 1985 · S/N R18202021N6402QMooney Mooney Mooney LLC · Gig Harbor, WABuilt 1967 · S/N 670142N6402UMccleave Thomas · Everett, WABuilt 1962 · S/N 2149N6402VG&M Aircraft Inc · Wheat Ridge, COBuilt 1980 · S/N 172RG0664N64034State Of Louisiana · Baton Rouge, LABuilt 1981 · S/N 17275507N64035Loomis Darwin · Mooreland, OKBuilt 1975 · S/N 17264980N6403EGultch Dale R · Brookfield, WIBuilt 1959 · S/N 46503N6403JDog House Aviation LLC · Houston, TXBuilt 1968 · S/N 28-4819N6403PDiemand Larry L · Mentor, OHBuilt 1959 · S/N 24-1513N6403QMiller Fred J · Sahuarita, AZBuilt 1967 · S/N 670143N6403VVista Aviation Inc · Pacoima, CABuilt 1980 · S/N 172RG0665N6403WDanford Scott M · Chickamauga, GAS/N 28-20471N64040Golding Donald J · Tucson, AZBuilt 1981 · S/N 17275509N64043Aira Aviation LLC · Grand Ledge, MIFirst renewal noticeBuilt 1975 · S/N 17264981N64045Walker Robert · Chula Vista, CABuilt 1975 · S/N 17264983N64046Biesecker Michael Gary · High Point, NCBuilt 1975 · S/N 17264984N64048Gray Peter A · Salinas, CABuilt 1975 · S/N 17264986N6404JMorgan Donelle C · Cambria, CABuilt 1968 · S/N 28-4820N6404PNickell Paul D · Milo, IABuilt 1959 · S/N 24-1514
Back to AD 87-10-06 R1