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.

N6455PHussey Wilfred Lee II · Martinsville, VABuilt 1959 · S/N 24-1570N6455SDaniel L Cooper · Palmer, AKBuilt 2003 · S/N AF18022N6455VCrown Flying Club Inc · Olathe, KSBuilt 1981 · S/N 172RG0711N6456JCherokee Dream Inc · Wilmington, DEBuilt 1968 · S/N 28-4877N6456QLeehey Studio LLC · Santa Monica, CABuilt 1967 · S/N 670535N6456RCash Douglas Edward · San Antonio, TXBuilt 1966 · S/N 28-21642N6456ZSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1961 · S/N 25-639N64575N64575 LLC · Cheyenne, WYBuilt 1982 · S/N 17275585N6457DTristar Aviation Services LLC · Hendersonville, TNBuilt 1979 · S/N 17272809N6457JHatcher Clifford J · Dallas, GABuilt 1968 · S/N 28-4878N6457QRegistered aircraftBuilt 1967 · S/N 670536N6457WWeston Keith M · Ogdensburg, NYBuilt 1964 · S/N 28-20530N64585Lay Lawrence W · Douglass, KSBuilt 1977 · S/N 7-0311N6458JFlorida Tectonics Inc · Weirsdale, FLBuilt 1968 · S/N 28-4880N6458PHutchison Joseph C · Mebane, NCBuilt 1959 · S/N 24-1573N6458VWilson David P · Lumberton, TXBuilt 1980 · S/N 172RG0714N6458WJones Larry · Clovis, NMBuilt 1965 · S/N 28-20531N6459LFalcon Financial Solutions · Meadow Vista, CABuilt 2000 · S/N 30018CN6459PJaeger Timothy S · Mukwonago, WIS/N 241574N6459RLogical Drive Inc · Siler City, NCBuilt 1966 · S/N 28-21645N6459ULinck Market Inc · Little Rock, ARBuilt 1962 · S/N 2205N6459WBillingsley Littleton C Jr · Spicewood, TXBuilt 1964 · S/N 28-20532N645AWHobart Aviation Inc · Akron, OHBuilt 1981 · S/N 28-8116305N645BCNolan Kevin J · North Bend, ORBuilt 1974 · S/N 32-7540056N645BHFedors David · Palmdale, CABuilt 1996 · S/N 025N645DBBailey Dennis L · Oakdale, CABuilt 2004 · S/N 24345N645DDAmes Donald L Trustee · Park City, UTBuilt 2010 · S/N 81775N645DTScenic Mountain Air Inc · Moose Pass, AKBuilt 1982 · S/N 18-8309022N645EJFogelin Eric S · Shasta, CABuilt 2008 · S/N 645EN645FLRule Charles Y · Mineral Point, WIBuilt 1971 · S/N 28-7125553N645FTFlorida Institute Of Technology · Melbourne, FLBuilt 2013 · S/N 2843705N645LCJohnston Laura S · Seattle, WABuilt 2003 · S/N 263N645NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881146N645RD&S Development LLC · Spring, TXBuilt 1964 · S/N 30-240N645RDVeterinary Surgical Supply (Vss) LLC · Kalispell, MTBuilt 2009 · S/N 90541N645RFHagge Hal E · Eagle River, AKBuilt 1968 · S/N 18-8711N645SStewart Dennis M · Fernley, NVBuilt 2015 · S/N 72943N645SAGerrish Ronald M · San Antonio, TXBuilt 2005 · S/N S-0007N645SDDacy Julia A · Harvard, ILBuilt 1964 · S/N 30-524N645SPRegistration Pending · Bennett, CORegistration pendingBuilt 1998 · S/N 172S8052N64608A S Air LLC · Lantana, FLS/N 17275592N6460DVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1947 · S/N 19640N6460PAlpha Romeo Kilo Holdings Inc · Wilmington, DEBuilt 1959 · S/N 24-1575N6460QDel Gado Raul L · Victorville, CABuilt 1967 · S/N 670539N6460TDavey Douglas H · Worley, IDBuilt 1985 · S/N R18202031N6460UHayes Toby G · Idaho Falls, IDBuilt 1962 · S/N 2206N6460YRogers Anthony J · Boynton Beach, FLBuilt 1967 · S/N 27-3754N64611Great North Air LLC · Shelburne, NHBuilt 1982 · S/N 17275593N64617Melbourne Flight Training LLC · Melbourne, FLBuilt 1982 · S/N 17275594N6461CTripacer Strategic Consulting LLC · Dover, DES/N 28-7816425
Back to AD 87-10-06 R1