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.

N661MLDap Aviation LLC · Baton Rouge, LABuilt 1996 · S/N 4636060N661NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2020 · S/N 2881287N661PBravo Tango LLC · Minden, LABuilt 1980 · S/N 32R-8029080N661PC661pc LLC · New Rockford, NDBuilt 2004 · S/N T18208312N661QS&S Aircraft Inc · Bennington, VTBuilt 1959 · S/N TD-214N661RRHelicopter Of Columbia LLC · Columbia, SCBuilt 1999 · S/N 0661N661RVVans Rv6 Flyer Inc · Auburn Hills, MIBuilt 2003 · S/N 22938N661SDDarr Henry S · High Point, NCBuilt 1965 · S/N 24-4354N6620CDieck Steven L · Lake Villa, ILBuilt 1966 · S/N 3327N6620DPacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 17272907N6620LMc Gregor Daniel A · Denali Park, AKBuilt 1969 · S/N 31-554N6620PMagel David J · Lakemoor, ILBuilt 1960 · S/N 24-1741N6620RWhite Richard C · Tracy, CABuilt 1979 · S/N 172RG0217N6620VHall Steven R · Cambridge, MABuilt 1980 · S/N 172RG0784N66213Global Adventures N66213 LLC · Hollywood, FLBuilt 1983 · S/N 17275980N66215Channel Islands Aviation Inc · Camarillo, CABuilt 1983 · S/N 17275982N6621DCosta Air Service LLC · Painted Post, NYBuilt 1979 · S/N 17272908N6621JMardis David P · Warner Robins, GABuilt 1968 · S/N 28-5087N6621PR C Antique Aviation LLC · Saint Louis, MOBuilt 1960 · S/N 24-1742N6621RRasmussen Paul A · Lakewood, CABuilt 1974 · S/N M-1606N6621WGbg Aviation LLC · Foristell, MOBuilt 1965 · S/N 28-20717N6621YDyka Samuel M · Flushing, MIBuilt 1969 · S/N 27-4397N6622DArq Aviation LLC · Wilmington, NCBuilt 1979 · S/N 17272909N6622JBernstein Matthew D · North Charleston, SCBuilt 1968 · S/N 28-5089N6622UArmistead Jack R · Birmingham, ALBuilt 1963 · S/N 117N6622WBayko John T · Marengo, OHBuilt 1965 · S/N 28-20718N66230East Hill Flying Club Inc · Ithaca, NYBuilt 1983 · S/N 17275985N6623JAcadian Aviation Pilot Training Centre Inc · Lafayette, LAS/N 28-5090N6623PHopkins Daryl L · Gentry, ARBuilt 1959 · S/N 24-1744N6623YOrtner Airport LLC · Wakeman, OHBuilt 1968 · S/N 27-3930N6623ZMage Aircraft Leasing LLC · San Antonio, TXBuilt 1980 · S/N 172RG0240N6624ARegistered aircraftBuilt 1981 · S/N 18-8109029N6624GBob Hoover Academy · Salinas, CABuilt 1979 · S/N 17273611N6624HSakata Lissa C · Falls Church, VAS/N 17265515N6624JN6624 LLC · Reserve, LABuilt 1968 · S/N 28-5091N6624PMiller David J · Washington, IAFirst renewal noticeBuilt 1960 · S/N 24-1746N6624VDahle Jeffrey R · Ashland, ORBuilt 1970 · S/N 31008N66251T Air LLC · Bonita Springs, FLBuilt 1979 · S/N M-2178N6625DFox Valley Technical College · Oshkosh, WIBuilt 1979 · S/N ME-203N6625JJustice Andrew C · Amory, MSBuilt 1968 · S/N 28-5092N6625WR W Bright Architects Inc · Tulsa, OKBuilt 1965 · S/N 28-20722N6626DDrozs Allen P · Decatur, ILBuilt 1979 · S/N M-2179N6626JSn Aviation LLC · Richardson, TXBuilt 1968 · S/N 28-4919N6626UCramer Brett E · Sloughhouse, CABuilt 1963 · S/N 121N6627JYellowstone Flying Club · Billings, MTBuilt 1968 · S/N 28-4927N6627PMaddela Prabhuvaram J · El Mirage, AZBuilt 1959 · S/N 24-1750N6627WSemprimoznik Jeffery J · Davenport, WABuilt 1965 · S/N 28-20724N6627YMiller Jay M DBA · Grantsville, MDBuilt 1969 · S/N 27-4399N6628EPhillips Alan K · Junction City, ORBuilt 1979 · S/N M-2181N6628JSiusta Donald W · Bryceville, FLS/N M-2182
Back to AD 87-10-06 R1