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.

N80952Registered aircraftBuilt 1976 · S/N 17266817N80959Mets Flying Club Inc · Fairmount, INBuilt 1976 · S/N 17266819N8095ADay Gordon Jr · Fort Atkinson, WIBuilt 1979 · S/N 28-7911329N8095GTrulock Todd N · Ontario, CABuilt 1979 · S/N 28-7911330N8095HSimmer Aviation LLC · Missoula, MTBuilt 1979 · S/N 28-7911331N8095PGramas Illya W · Shelby, MIBuilt 1962 · S/N 24-3344N8095WSkierka Michael A · Browning, MTBuilt 1965 · S/N 28-2189N8095YN8095y Inc · Oakdale, MNBuilt 1966 · S/N 30-1213N80960Perry Robert Lawrence Trustee · Salinas, CABuilt 1946 · S/N 1153N80961A S Air LLC · Lantana, FLBuilt 1976 · S/N 17266820N80964Three Wing Flight School LLC · Stratford, CTBuilt 1981 · S/N 28-8216108N80968Wisconsin Aviation Inc · Watertown, WIBuilt 1979 · S/N 28-8016087N8096JBullgoose Aviation Inc · York, PANon-citizen corporation, flight hours not reportedBuilt 1979 · S/N 32R-8029006N8096LRhinebeck Aerodrome Museum · Rhinebeck, NYBuilt 1999 · S/N 1999N8096PTsacoyianis Jonathan J · Pascoag, RIBuilt 1962 · S/N 24-3345N8096QHoover Charles J · Logansport, INBuilt 1981 · S/N 28-8216107N8096SFreedom Aircraft Jv 1 LLC · Milton, FLBuilt 1979 · S/N 32R-8013006N8096VPlatt Philip L · Concho, AZBuilt 1979 · S/N 32R-8013007N8096WRoberts Heather V · Birmingham, ALBuilt 1965 · S/N 28-2190N80972Porter Timothy D · Saint Cloud, MNBuilt 2000 · S/N 60081N80975N80975 LLC · Wilmington, DEBuilt 1976 · S/N 17266821N8097CImmell Michael · Buffalo, OKBuilt 1975 · S/N 32-7640052N8097HMiloud Chadd K · Fort Worth, TXBuilt 1979 · S/N 28-8016092N8097JAjdari Rodmehr · Millville, NJBuilt 1979 · S/N 28-8016093N8097PEmery Jonathan D · Payson, AZBuilt 1979 · S/N 28-8090106N8097QHissey Mark E · Fannettsburg, PABuilt 1980 · S/N 28-8090107N8097SBrookwood Plastering Inc · San Diego, CABuilt 1979 · S/N 28-8090108N80982Reiselt Paul T F · Corinth, MSBuilt 1976 · S/N 17266825N80985Mullins James C · Franklin, TNBuilt 1976 · S/N 17266826N8098BIowa Aircraft Inc · Burlington, IABuilt 1979 · S/N 28-8090110N8098ERegistered aircraftN-number assigned, not yet registeredS/N 17272140N8098MRock Solid Aviation LLC · Lake Charles, LABuilt 1979 · S/N 28-8090111N8098NBlessing Gary · Cape Coral, FLBuilt 1968 · S/N 28-25342N8098PTaylor Edith E · Como, NCBuilt 1962 · S/N 24-3348N8098YPestair LLC · Wilmington, NCBuilt 1966 · S/N 30-1216N80991Flowers Robert Clyde III · Manchaca, TXBuilt 1976 · S/N 17266830N80996Halley Dan R · Avery, TXBuilt 1976 · S/N 17266832N8099NArthur Kezian Inc · Los Angeles, CABuilt 1979 · S/N 28-8011002N8099QKocher Gary E · Bellingham, WAS/N 28-8011004N8099VGrannetino Gerald F · West Chester, PABuilt 1971 · S/N 32-7140072N8099WClarion County Flight Club LLC · Shippenville, PABuilt 1965 · S/N 28-2194N8099YMs Aero Inc · Lakeville, OHBuilt 1966 · S/N 30-1217N809APPhillips William Wade · Lake Charles, LAS/N 21823N809BTLouisville Aircraft Leasing LLC · Louisville, KYBuilt 1976 · S/N 17267437N809BWGilly Christian · Newtown, PABuilt 2005 · S/N 27-0334N809CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281222N809DWReed Land & Properties LLC · Kalispell, MTBuilt 2002 · S/N T18208109N809EMDepartment Of Homeland Security · Washington, DCBuilt 2004 · S/N 20608213N809GTDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608245N809HWDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608248
Back to AD 87-10-06 R1