OpenAirDocs.org
AD 82-06-11 R1

Registered aircraft · 2,375

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:82-06-11-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:82-06-11-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.

N1747HRooks John S · Barrington, RIBuilt 1977 · S/N 28R-7703033N175WWMassari Edward Sr · Mount Laurel, NJS/N 28R-7703074N1765HMcumber James W · Elkin, NCS/N 28R-7703034N1795HJp Kelly Air LLC · Fort Smith, ARBuilt 1977 · S/N 28R-7703035N17AXWard Hugh W · Arlington, TXBuilt 1979 · S/N 28R-7931132N17FVStoltzfus Shawn D · Lancaster, PABuilt 1977 · S/N 28R-7737089N17MSDarcy Aviation LLC · Danbury, CTBuilt 1979 · S/N 28R-7918152N17SGHelisur USA LLC · Pembroke Pines, FLBuilt 1982 · S/N 28R-8231060N181DP181dp Aircraft Leasing LLC · Spanish Fork, UTS/N 28R-7335246N1820TCallender Richard · Presque Isle, WIBuilt 1971 · S/N 28R-7135122N187SASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1972 · S/N 28R-7235139N190FTWestchester Flying Club Inc · Purchase, NYBuilt 1978 · S/N 28R-7837245N1912THillman Motors Inc · Winter Haven, FLBuilt 1971 · S/N 28R-7135130N1915TAeromx LLC · West Jefferson, OHBuilt 1971 · S/N 28R-7135132N191BCZabrosky Air LLC · Cedar Hills, UTBuilt 1973 · S/N 28R-7435088N1927HAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1977 · S/N 28R-7737017N1939HChicas-Terrill Roger Daniel · Anaheim, CABuilt 1977 · S/N 28R-7737018N1940TC140 Co LLC · Milton, FLBuilt 1971 · S/N 28R-7135138N1946TDja Aviation LLC · Middletown, DEBuilt 1971 · S/N 28R-7135140N1952HAmpersand Air Inc · Camp Hill, PABuilt 1977 · S/N 28R-7703041N1952TLeardo Inc · Plano, TXS/N 28R-7135185N1956SRegistered aircraftBuilt 1975 · S/N 28R-7535164N1957TPipers Are Still Better LLC · Carson City, NVBuilt 1971 · S/N 28R-7135177N1960TRay Steven B · Fort Collins, COBuilt 1971 · S/N 28R-7135173N1963TCondor Aero Club Inc · Zelienople, PABuilt 1971 · S/N 28R-7135192N1980HEf Aviation LLC · Cape Coral, FLS/N 28R-7703044N1986HTraining Planes LLC · Tampa, FLS/N 28R-7737022N1987HFour C Sons Inc · Kersey, COBuilt 1977 · S/N 28R-7703046N1989TJ3bar Pilot Services LLC · Garden City, KSBuilt 1971 · S/N 28R-7135203N1993TDenali Management Inc · Encino, CABuilt 1971 · S/N 28R-7135211N1994THelisur USA LLC · Pembroke Pines, FLS/N 28R-7135187N1996HLord Alan T · Reynoldsburg, OHBuilt 1977 · S/N 28R-7737023N1997HScarry Daniel · San Luis Obispo, CABuilt 1977 · S/N 28R-7703047N199JBOew Aviation LLC · Sumter, SCBuilt 1971 · S/N 28R-7135100N199PGArnett Joshua · Lucas, TXBuilt 1982 · S/N 28R-8218020N199PKSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 28R-35694N19PAAkradi Parviz Trustee · Laguna Niguel, CABuilt 1977 · S/N 28R-7803129N1QABender Edward C Jr · Lansdale, PABuilt 1973 · S/N 28R-7335303N2007MCritz Sue A · El Paso, TXBuilt 1977 · S/N 28R-7837061N200ACKerstetter Michael S · Hewitt, NJBuilt 1969 · S/N 28R-35656N200DWLillian Aviation LLC · Cypress, TXBuilt 2003 · S/N 2844102N200EFLame Deer LLC · Flemington, NJBuilt 1977 · S/N 28R-7703168N200GKSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 28R-7335287N200JKRuiz Victor · Roscommon, MIBuilt 1974 · S/N 28R-7435255N200KRDusek Ryan · Cypress, TXBuilt 1976 · S/N 28R-7635176N200NTRichmond Jeremy · Eufaula, OKS/N 28R-35321N200RLAlpha Aviation Services LLC · Chelsea, ALBuilt 1969 · S/N 28R-35210N200WAYoedhana Christian · Pflugerville, TXBuilt 1973 · S/N 28R-7335363N2018MSanders Drew C · Cortez, COBuilt 1977 · S/N 28R-7803100N202WFPro Express LLC · Alliance, NEBuilt 1978 · S/N 28R7803325
Back to AD 82-06-11 R1