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.

N81749Friend Aircare Inc · Washington, PABuilt 1982 · S/N 28-8290107N8174MFlight Time Builders Inc · Memphis, TNBuilt 1972 · S/N 17260574N8174PIglewski Rudolph Daniel II · Apache Junction, AZBuilt 1963 · S/N 24-3430N8174WJeffers Coreen · Bellmawr, NJBuilt 1965 · S/N 28-2298N8174XJones Aaron B · Bruceton Mills, WVBuilt 1980 · S/N 28-8011067N8174YStansbury Todd V · Centennial, COS/N 30-1289N81756Jrny Air LLC · Everett, WABuilt 1982 · S/N 32R-8313013N8175CYates Trucking Inc · Quartz Hill, CABuilt 1975 · S/N 28R-7635132N8175EHigh Planes Aviation LLC · Goodland, KSBuilt 1959 · S/N 1446N8175HHowe Richard B · San Luis Obispo, CABuilt 1980 · S/N 28-8016292N8175NClassical Organs Of Texas LLC · Liberty Hill, TXBuilt 1982 · S/N 32-8206030N8175PCunningham James L · Tucson, AZBuilt 1963 · S/N 24-3431N8176CShaffer Glenn · Vinemont, ALBuilt 1954 · S/N 18-3632N8176PHundley Jeffrey S · Parker, COBuilt 1963 · S/N 24-3432N81771Skyfusion II LLC · Atlanta, GABuilt 1980 · S/N 28-8090269N81774Pc Limited LLC · N Dighton, MABuilt 1982 · S/N 32-8206015N8177NAspiras Dionisio O Jr · Rosharon, TXBuilt 1968 · S/N 28-25373N8177WDavis James Warren · Albemarle, NCBuilt 1965 · S/N 28-2301N8177YElite Approach LLC · Chesterfield, MOBuilt 1982 · S/N 32R-8229042N81795Flat Land Aviation & Training LLC · Seward, NEBuilt 1980 · S/N 32R-8013080N8179AFelker Lonnie A · Burbank, CABuilt 1980 · S/N 28-8011065N8179HSam Air LLC · Daphne, ALBuilt 1982 · S/N 28-8216138N8179NFletcher William J · Mason, NHBuilt 1968 · S/N 28-25375N8179THill Jason M · Bakersfield, CABuilt 1960 · S/N 17556879N8179WLynch Gary L · Ocala, FLBuilt 1965 · S/N 28-2303N8179ZGambacorta Paul E · Leonardtown, MDBuilt 1980 · S/N 32-8006024N817ABHawaii Pacific Aviation Inc · Kailua Kona, HIS/N 1258N817ACCannon Air Force Base - Aero Club · Clovis, NMBuilt 2003 · S/N 2842190N817AKZweifel Brad · Palmer, AKBuilt 1958 · S/N 55101N817BWWalker Baylor L · Big Spring, TXBuilt 2001 · S/N S1813N817CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281257N817DHMastrangelo John A · Phoenix, AZBuilt 2003 · S/N 1341-2003N817DMRegistered aircraftBuilt 2007 · S/N 40401N817GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881465N817HAIasco Flight Training Inc · Redding, CABuilt 1999 · S/N 17280828N817HSMoore Stephen T · Ellensburg, WABuilt 2012 · S/N 91132N817JJenkins Jay T · Burnsville, MNBuilt 1999 · S/N 80017N817JCCain Jerome M · Lincoln, MTBuilt 1999 · S/N 1465N817JVRusyniak Anthony J · Syracuse, NYBuilt 1995 · S/N 1283N817KBaquero Eric P · New Castle, COBuilt 1963 · S/N 24-3445N817KCCrawford Michael R · Gainesville, GABuilt 1976 · S/N AS-1N817LHHavelka Lambert H · Mc Gregor, TXBuilt 2017 · S/N 41054N817NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881047N817TFAir Fleet Holdings LLC · Missoula, MTBuilt 2022 · S/N 2881594N817TRRobinson Trent · Havana, FLBuilt 2000 · S/N 3257132N817YLandon William Walton IV · Fairbanks, AKS/N 8085-CN817ZBennett Condon P · Stormville, NYBuilt 1976 · S/N 17266787N81809Corporation Of The Catholic Archbishop Of Anchorag · Anchorage, AKBuilt 1980 · S/N 28-8016221N8180CSnoopy Air LLC · Kalispell, MTBuilt 1954 · S/N 18-3637N8180DBobert Bunny LLC · Wilmington, DEBuilt 1980 · S/N 32R-8029075
Back to AD 87-10-06 R1