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.

N809KPDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608249N809LNDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608251N809MBerkshire Aviation Enterprises LLC · Great Barrington, MABuilt 1977 · S/N 28R-7837015N809NDDepartment Of Homeland Security · Washington, DCBuilt 2004 · S/N 20608219N809PGDepartment Of Homeland Security · Washington, DCBuilt 2003 · S/N 20608190N809QJDepartment Of Homeland Security · Washington, DCBuilt 2004 · S/N 20608209N809RHDepartment Of Homeland Security · Washington, DCBuilt 2004 · S/N 20608210N809SEDepartment Of Homeland Security · Washington, DCBuilt 2003 · S/N 20608208N809STDiaz Natanael Luna · Toa Baja, PRS/N 17268873N809TFAir Fleet Holdings LLC · Missoula, MTBuilt 2024 · S/N 2881702N809TTDepartment Of Homeland Security · Washington, DCBuilt 2004 · S/N 20608211N809USDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608231N809VADepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608232N80AMGreat Lakes Aircraft LLC · Palmer Lake, COBuilt 1980 · S/N 0829N80ANStephany Peter T · Umatilla, FLBuilt 1980 · S/N 18-8109003N80ASAlpha Sierra LLC · Simi Valley, CABuilt 1992 · S/N 5244N80BADelcambre Willard J · Grand Coteau, LABuilt 2009 · S/N 7093N80BDJtr Aviation LLC · Canton, TXBuilt 1980 · S/N 613-80N80BJRegistration Pending · Jasper, GARegistration pendingBuilt 1977 · S/N 18-7709191N80BRN80br LLC · Port Orange, FLBuilt 1967 · S/N 32-913N80CEGarden Kevin · Collierville, TNS/N EAGLE 0001N80CHMoyer Hunter · Rapid City, SDS/N AA5B-0496N80DECampbell Bradford D · Groton, CTBuilt 1973 · S/N 74-31083N80DJShireman Kirk A · Pearland, TXBuilt 1981 · S/N 32R8129081N80DKAutoair Research Inc · Wilmington, DEBuilt 1994 · S/N 1685N80EEEagle Enterprise LLC · Granbury, TXBuilt 1982 · S/N MAY-0001N80ERModular Solutions Inc · Kinston, NCBuilt 2004 · S/N 71N80EZHolliday Mathew J · Limerick, PABuilt 1988 · S/N 941N80FFP A M Aviation LLC · Portsmouth, NHBuilt 1972 · S/N 27-7304958N80FGFlightgest Academy LLC · Morrisville, NCBuilt 2022 · S/N 2881562N80FPCarastro Enterprises LLC · Montgomery, ALBuilt 1978 · S/N 17271343N80FTWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 2000 · S/N 2842078N80GGOgg Richard A · San Lorenzo, CABuilt 1996 · S/N 7N80GLNear William J · Weirsdale, FLBuilt 1980 · S/N 0GL-0125N80GSCassell Robert W · Wasilla, AKBuilt 2005 · S/N 5350N80GVMoro Aircraft Leasing Inc · Two Rivers, AKBuilt 1975 · S/N 31-7552003N80HULast Waterhole LLC · West Richland, WAS/N 1326N80HYBrooks Eugene D IV · Cross Plains, TNBuilt 2005 · S/N 2288N80JVBaker Aviation Consulting LLC · Summerland Key, FLBuilt 2015 · S/N 1207N80KARowe Andrew · Palmdale, CABuilt 1972 · S/N 28R-7235166N80KDKnutson Kevin J · Lakeville, MNBuilt 2013 · S/N 24977N80KMMcphillips Flying Service Inc DBA · Beaver Island, MIBuilt 1969 · S/N 80N80LCHubbert Stephen A · Newcastle, OKBuilt 1993 · S/N 38N80LFAeromarine Holdings LLC · Waukesha, WIBuilt 2001 · S/N 127N80LKEti Aviation LLC · Boynton Beach, FLBuilt 1977 · S/N 31-7712103N80LSClow Streeter M · Mansfield, OHBuilt 1976 · S/N 18-7609096N80LTEastern Stearman Inc Trustee · Leesburg, VABuilt 1996 · S/N 1786N80MLBishop Jack · Sabina, OHBuilt 1980 · S/N 28R-8018007N80MMTodd Patrick A · Lockeford, CABuilt 1980 · S/N 249N80NDMerrifield Robert Craig · Fitzgerald, GAS/N 24-4164
Back to AD 87-10-06 R1