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.

N7598WSmith Cameron · Billings, MTBuilt 1964 · S/N 28-1552N7599CHurd Air LLC · Sioux Falls, SDBuilt 1975 · S/N 28R-7635102N7599GJones James D · Linden, NCBuilt 1970 · S/N 17259299N7599JZurro Roger M · Freehold, NJBuilt 1969 · S/N 28R-30997N7599LAviation Pursuits Inc · Carrollton, GABuilt 1974 · S/N 31-7400988N7599RHoffman Harold O · Andrews, TXBuilt 1966 · S/N 28-22167N759CHadley Jean C · Benbrook, TXBuilt 2004 · S/N 3257365N759EEAcadiana Technical College · Lafayette, LABuilt 1979 · S/N R18201241N759LBBrown Larry W · The Villages, FLBuilt 2015 · S/N 72058N759STraining Planes LLC · Tampa, FLBuilt 1974 · S/N 17264166N75AKC U Later Aviation LLC · Holliday, TXBuilt 2005 · S/N T18208376N75ALTeebagy Steven C · Wellington, FLBuilt 1973 · S/N 17701927N75ARRegistered aircraftBuilt 1982 · S/N 1026N75BFScussel Edward D · Albuquerque, NMBuilt 1975 · S/N 792-75N75BPPearce William R · Grants Pass, ORBuilt 2004 · S/N 80351N75CEInternational Air Services Inc Trustee · Carson City, NVBuilt 1991 · S/N GA0032N75CJAngels Ten LLC · Norfolk, VABuilt 1996 · S/N 001SRN75CMLowe Kenneth W · Sea Island, GABuilt 1975 · S/N 1N75DFShelley Michael D · Murfreesboro, TNBuilt 1964 · S/N 290N75DRBurton Stuff LLC · Carlsbad, CABuilt 1978 · S/N 32R-7887163N75ECMaxson Phillip W · Green Cove Springs, FLBuilt 2010 · S/N 90739N75GDCurren Scott N · Prospect, OHS/N GED-1N75GPCross Colton · Allons, TNBuilt 1968 · S/N 28-4882N75HDMorton Michael E · Hickory, NCS/N 30-757N75HRMountain Flyer Aircraft LLC · Kalispell, MTS/N 247N75JADomenick James V · Placitas, NMBuilt 1997 · S/N 22946N75JEHammer Motion Pictures Inc · Indianapolis, INBuilt 1975 · S/N 32-7540164N75JGWhisenant Roy H II · Poway, CABuilt 1975 · S/N M-1716N75JRWillis James R · Belleview, FLBuilt 1965 · S/N 1484-174N75JWCompher Charles D · Berryville, VABuilt 1981 · S/N JW-1N75KAmra Nabil W · Chaska, MNBuilt 1987 · S/N 461N75KAN75ka LLC · Fort Washington, MDBuilt 1997 · S/N 94-0067N75KDJp1 LLC · San Angelo, TXBuilt 1998 · S/N 4636178N75KJSeiter Gene G · Pleasant View, TNBuilt 2016 · S/N 1179N75KMEverett Kevin · Peoria, ILBuilt 2009 · S/N 153N75KRRoss Kevin · Granbury, TXBuilt 2001 · S/N 60533N75LKN75lk LLC · Lafayette, LABuilt 1981 · S/N 31-8152173N75LLDavis Air LLC · Phoenix, AZBuilt 2005 · S/N 31N75MMDonney Tom J · Sturgis, SDBuilt 1975 · S/N 824-75N75NSJohnson Dale B · Steele, NDBuilt 1968 · S/N 17257539N75PDHaher Thomas R · Tully, NYBuilt 2000 · S/N 18280683N75PHPaper House Av Inc · Locust Valley, NYS/N 27-0222N75RBBarr Air Patrol LLC · Mesquite, TXS/N 18280011N75SDVimco N75sd LLC · El Paso, TXBuilt 1973 · S/N 17260829N75SEJansen Adam Roger · Sunnyvale, CABuilt 2005 · S/N 495-2005N75SGW E Love Ranch · Marfa, TXBuilt 2000 · S/N 3257175N75TBMorse George A · Prescott, AZS/N 537N75TCMorales Luis · Florence, ORBuilt 1977 · S/N 17268913N75TDMcmonagle Donald R · Westcliffe, COS/N 2136N75TJSantos Jorge · Shafter, CABuilt 2003 · S/N 22633
Back to AD 87-10-06 R1