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.

N969QLindbergh Aviation LLC · Linden, MIBuilt 1961 · S/N TD-495N969RAFox Valley Technical College · Oshkosh, WIBuilt 1980 · S/N ME-317N969RRDodson International Parts Inc · Rantoul, KSBuilt 1982 · S/N 17275850N969SDThompson James R · Warren, OHS/N 28-7225045N969SHDominguez Philip · Brooklyn, NYBuilt 1977 · S/N AA5B-0418N969SPB R S Leasing Inc · Wilmington, DEBuilt 1999 · S/N 172S8171N969TALola Cattle Co LLC · Rio Grande City, TXBuilt 2003 · S/N 1300N969TTSmoketown Flight Center LLC · Smoketown, PABuilt 1973 · S/N 17261635N969WCTexas State Aviation · San Marcos, TXBuilt 2001 · S/N 260010N96ANCostabile Gregg D · Baker, FLBuilt 1996 · S/N 24497N96AWPlanenutz LLC · Deland, FLBuilt 1966 · S/N 3289N96BConservative Three LLC · Taft, CABuilt 1998 · S/N 101N96BTAnema Daniel W · Groveland, CABuilt 1996 · S/N 052N96CMCarson Sundance Lucas · Canyon Lake, TXBuilt 1996 · S/N 2544N96CWHarger Aviation LLC · Richmond, TXBuilt 2005 · S/N 599N96DCVertical Horizon Aviation LLC · Sandown, NHBuilt 1960 · S/N 18-7284N96DLDurashok LLC · Panama City, FLBuilt 1988 · S/N 883N96DSAldea Da40 LLC · Summerville, SCBuilt 2010 · S/N 40.1096N96DTPierson Richard R · Galesville, WIBuilt 1978 · S/N 28-7990230N96EBBills Curt R · Dimmitt, TXBuilt 2008 · S/N 82695N96ELJimenez-Cruz Juan C · Mayaguez, PRBuilt 1966 · S/N 28-3615N96EZBurk Ross · Casper, WYS/N 1321N96FDPb Marchetti LLC · West Palm Beach, FLBuilt 1990 · S/N 783N96FRWoodward-Davis LLC · Nacogdoches, TXBuilt 1980 · S/N 17274184N96FSSmidler Francis S · Zionsville, INFirst renewal noticeBuilt 2008 · S/N 21585N96GFHile Phillip J · Harrison, OHBuilt 1996 · S/N 633-320-378N96GWStranberg Jonathan E · White Heath, ILBuilt 1996 · S/N 910N96HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 1978 · S/N ME-30N96HGHawdon Neil J · Federal Way, WABuilt 2002 · S/N 357RN96HHRitzenthaler Hugo A · Rochester Hills, MIBuilt 1984 · S/N 8-0100N96JBSigman Bruce A · East Brunswick, NJBuilt 1969 · S/N 32-40722N96JDMorehouse Gregory · Missoula, MTBuilt 2004 · S/N 27-0327N96JNPetz Leroy E Jr · Montverde, FLBuilt 1985 · S/N 39-91N96JPMclean William E · Daleville, ALBuilt 2002 · S/N 1437N96KMijangos Adrian E · Mary Esther, FLBuilt 1977 · S/N 28-7725269N96KCJws Aviation LLC · Easton, CTBuilt 1997 · S/N 3246087N96KEAbb Aviation LLC · Hammond, LABuilt 2015 · S/N 40231N96KSMower Douglas D · Cedar Ridge, CAS/N 24-3361N96LEStroud Michael L · Kemmerer, WYBuilt 2000 · S/N 60083N96LJHiller Alex T · Lake Orion, MIBuilt 1997 · S/N 737N96LZRegistered aircraftBuilt 2025 · S/N 590N96MERegistration Pending · Redmond, ORRegistration pendingBuilt 1996 · S/N 14071CN96MKKukulski Michael · Grayslake, ILBuilt 1998 · S/N 1811N96MLM & M Aero LLC · Wilmington, DEBuilt 1978 · S/N 32-7940009N96NHMeade John P · Wentworth, NHBuilt 2025 · S/N 69P-149P/150P-P446N96PCMurphy Walter · Sparks, NVBuilt 1999 · S/N GS-5482N96PJCarter Bruce J · Longboat Key, FLBuilt 1996 · S/N 0203N96PPSwam Air LLC · Edinburg, VABuilt 1997 · S/N 4636120N96RDZonczyk Micheal · Keene, NHBuilt 1995 · S/N 214N96RGKim Sung S · Upland, CABuilt 1975 · S/N RBGII
Back to AD 87-10-06 R1