OpenAirDocs.org
AD 82-23-01 R1

Registered aircraft · 3,118

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-23-01-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-23-01-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.

N5074PShingledecker Robert K II · Ozark, ARBuilt 1958 · S/N 24-80N5078PPutnam Andrew L · New Limerick, MEBuilt 1958 · S/N 24-84N5088CMike Golf Holdings LLC · Pinellas Park, FLBuilt 1964 · S/N 30-497N5088PKesser Gilbert M · Culpeper, VABuilt 1958 · S/N 24-94N5091PSpicuzza Robert A · Waterford, MIBuilt 1958 · S/N 24-100N5093PAir Chutney LLC · Waynesboro, VABuilt 1958 · S/N 24-102N5099PSelinger Richard L · Murrieta, CABuilt 1958 · S/N 24-109N50TDPa-30 LLC · Appleton, WIBuilt 1965 · S/N 30-827N5100PHuntcliff Air Services LLC · Atlanta, GABuilt 1958 · S/N 24-105N5107PStranton Air LLC · Harvard, ILS/N 24-117N5114PParris David T · Virginia Beach, VABuilt 1958 · S/N 24-126N5115PSmith James Kelly · Newark, OHBuilt 1958 · S/N 24-127N5117PMarsteller Michael A · Lugoff, SCBuilt 1959 · S/N 24-130N5118PMeng Marvin Allen Jr · Edwardsville, ILBuilt 1958 · S/N 24-131N5126PElie Jonathan · Hopewell Junction, NYBuilt 1958 · S/N 24-139N5128PSchafer David · Northport, ALBuilt 1958 · S/N 24-141N5130PWhite Guy B · Waxahachie, TXBuilt 1958 · S/N 24-143N5132PMccormick Geoffrey D · Goodyear, AZBuilt 1958 · S/N 24-145N5136PDunn James F · Salem, INBuilt 1958 · S/N 24-150N5137PFrancis Himanshu Raj · Blythewood, SCBuilt 1958 · S/N 24-151N5141PWest Texas Weather Modification Association · San Angelo, TXBuilt 1958 · S/N 24-156N5142PBritz Store Equipment Inc · Buckman, MNBuilt 1958 · S/N 24-157N5143PUnusual Attitudes LLC · Bates City, MOBuilt 1958 · S/N 24-159N5147PDunn Paul S Trustee · Santa Fe, NMBuilt 1958 · S/N 24-163N5148PRegistered aircraftBuilt 1958 · S/N 24-164N5150PPeterson Richard A · Entiat, WABuilt 1958 · S/N 24-166N5151PHone Ryan L · West Richland, WABuilt 1958 · S/N 24-167N5153PCjl Aviation LLC · Dover, DEBuilt 1958 · S/N 24-169N5154PPerry Billy C · Newburgh, INBuilt 1958 · S/N 24-170N515SRegistration Pending · Azle, TXRegistration pending, pending cancellationS/N 24-3609N5161PN5161p LLC · Upland, CABuilt 1958 · S/N 24-177N5162PHorton Melody A · Diamondhead, MSBuilt 1958 · S/N 24-178N5163PReynolds David A · Blacksburg, VAS/N 24-179N5164PUpton John B · Lakeland, FLBuilt 1958 · S/N 24-180N5167PSoutheast Airways LLC · Gainesville, GABuilt 1958 · S/N 24-184N5169PStockdale Alexander Ian · Los Banos, CAS/N 24-187N5170PBosch Christopher J · Bloomington, MNBuilt 1958 · S/N 24-188N5173PColorado Aviation Group LLC · Colorado Springs, COS/N 24-192N5179PHangar 17 LLC · Sheridan, WYBuilt 1958 · S/N 24-199N5180PN5180p LLC · Willow Springs, MOBuilt 1958 · S/N 24-201N5181PFritz Joseph L · Eufaula, OKBuilt 1958 · S/N 24-202N5182PThede Dondi I · Marshall, WIBuilt 1958 · S/N 24-203N518CMTreakle Robert W · Austin, TXBuilt 1967 · S/N 30-1594N5194PBighorn Bifrost LLC · Sheridan, WYS/N 24-218N5195PWilliamsen Wesley · Benedict, NEBuilt 1958 · S/N 24-219N51BGProctor Stephen Patrick · White Lake, MIS/N 24-3017N51DSCulbertson William T · Helena, MTBuilt 1959 · S/N 24-1201N5203PFischer Steven A Trustee · Cary, ILBuilt 1958 · S/N 24-226N5205PCope N H · Lamesa, TXBuilt 1958 · S/N 24-228N5206PHyde Roy Wiliam · Sacramento, CABuilt 1958 · S/N 24-229
Back to AD 82-23-01 R1