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.

N704FLBabri Masood A · Lorton, VABuilt 1972 · S/N 28-7225256N704MBBrekke Aerial Service Inc · Edmore, NDBuilt 1977 · S/N 18-7809015N704MCCrowther Construction Inc · Pleasant View, UTBuilt 2004 · S/N T18208251N704MRCoco Aircraft Inc · Merritt Island, FLBuilt 1989 · S/N 2841181N704NDUniversity Of North Dakota · Grand Forks, NDBuilt 2017 · S/N 2843873N7050DFoster David S · Justin, TXS/N 56-0551N7050GAircraft Management Group Inc · Honolulu, HIBuilt 1969 · S/N 17258750N7050PBork Joseph L · Mosier, ORS/N 24-2199N7050QMindy Limited LLC · Muscatine, IABuilt 1972 · S/N 17260350N7050YTonys Aerial Service Inc · Great Bend, KSBuilt 1963 · S/N 30-53N7050ZMid Continent Aircraft Corp · Hayti, MOBuilt 1964 · S/N 25-2818N7051State Of Alaska · Anchorage, AKBuilt 1953 · S/N 18-2932N7051DBraun Ronald J · Wasilla, AKBuilt 1957 · S/N 22-4948N7051GWein Greggory J · Convoy, OHBuilt 1969 · S/N 17258751N7051QBright Flight Aviation Inc · Jacksonville, FLBuilt 1972 · S/N 17260351N7051RBest Equipment Leasing LLC · Bakersfield, CABuilt 1966 · S/N 28-21749N7052State Of Alaska · Anchorage, AKBuilt 1968 · S/N 18-8729N7052DMundell Lola Trustee · Rosston, OKBuilt 1967 · S/N 67-16739N7052FStephens Racquel C · Laguna Niguel, CABuilt 1976 · S/N 28-7790179N7052GG&H Aviation · Louisville, KYBuilt 1969 · S/N 17258752N7052HScruggs Ken · Galloway, OHBuilt 1975 · S/N 27-7554130N7052PFlying Great Danes LLC · Chesapeake, VABuilt 1960 · S/N 24-2201N7052QHoloman T Michael · New Smyrna Beach, FLBuilt 1972 · S/N 17260352N7052RSell Carl N · Spanaway, WABuilt 1966 · S/N 28-21750N7052VOut Front Cc LLC · Kalispell, MTBuilt 2012 · S/N 2243N7052WPuskala Thomas S · Iron River, MIBuilt 1962 · S/N 28-817N7053Jsrs Holdings LLC · Las Cruces, NMBuilt 1968 · S/N 18-8730N7053BStevens Alan · Meridian, IDBuilt 1956 · S/N 22-4307N7053GSpare Change Enterprises LLC · Atlantic, IABuilt 1969 · S/N 17258753N7053LVelvick Kathleen R · Peoria, AZBuilt 1989 · S/N WJ-1N7053PManter Earl F · Delaware, OHBuilt 1960 · S/N 24-2202N7053QCabrie Aviation Inc · Charlotte, NCBuilt 1972 · S/N 17260353N7053WRed Rock Flying School LLC · Mesa, AZBuilt 1962 · S/N 28-805N7054State Of Alaska · Anchorage, AKBuilt 1971 · S/N 18-8915N70541Cl Finney Aviation LLC · Benton, KSBuilt 1969 · S/N 17258757N70543Tk Group Holdings LLC · Wilmington, DEBuilt 1976 · S/N 31-7612029N70549Andersen Mark · Huntley, ILBuilt 1993 · S/N 10152N7054BWinter Jerry L · Cumming, GAS/N 22-4310N7054GSands Aviation LLC · Talking Rock, GAS/N 67-16871N7054WLanguage Gert Johannes · Hays, KSS/N 28-820N7054YNordman Clay L · Catheys Valley, CABuilt 1963 · S/N 30-65N7055State Of Alaska · Anchorage, AKBuilt 1971 · S/N 18-8916N7055PKehrle Betty M · Chandler, AZBuilt 1960 · S/N 24-2205N7055QSeagraves Brad J · Rockwell, NCBuilt 1972 · S/N 17260355N7055RRegistered aircraftBuilt 1966 · S/N 28-21754N7055WRickard Donald L · Rowland Hts, CABuilt 1962 · S/N 28-823N7056State Of Alaska · Anchorage, AKBuilt 1971 · S/N 18-8917N70562Jets To Helis LLC DBA · Chandler, AZBuilt 2001 · S/N 3281N7056PSelf Melvin Lamar Jr · Greenwood, MSBuilt 1960 · S/N 24-2206N7056QFleeman Joseph R · Lawrenceburg, TNBuilt 1972 · S/N 17260356
Back to AD 87-10-06 R1