OpenAirDocs.org
AD 82-23-03 R1

Registered aircraft · 1,185

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-03-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-03-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.

N850SXN850sx LLC · Lewes, DEBuilt 1994 · S/N 258270N850XMHawker Jet Holdings Xp1 LLC · Opa Locka, FLS/N 258426N851CGBank Of Utah Trustee · Salt Lake City, UTS/N 59N851LDodson International Parts Inc · Rantoul, KSFirst renewal noticeBuilt 1977 · S/N 114N855MWMunguia Mario · Downey, CABuilt 1993 · S/N 258241N855RJJw-N855rj LLC · Mcallen, TXBuilt 1981 · S/N 009N858SPBrown Lawson M II · San Diego, CABuilt 1974 · S/N 11N858WWMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1993 · S/N 064N85MSAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1985 · S/N 650-0075N85PTWestwind Air LLC · Oklahoma City, OKBuilt 1980 · S/N 285N85SVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1980 · S/N 347N85WTExcalibur International Aviation Inc · Spring, TXBuilt 1988 · S/N 650-0162N860JAAirborne Aviation LLC · Miami, FLBuilt 1998 · S/N 650-7086N864BFPsx LLC · Sheridan, WYBuilt 2002 · S/N 258584N865CSReef Aviation LLC · Knoxville, TNBuilt 2004 · S/N 136N865PCPapa Charlie LLC · Houma, LABuilt 1998 · S/N 271N867TXAirplane 1 LLC · Richmond, TXBuilt 2002 · S/N 258576N86BRBest Aircraft Deals LLC · Salt Lake City, UTS/N 90N86TNBravo Aviation LLC · Santa Rosa Beach, FLBuilt 1995 · S/N 241N870CKKalitta Charters LLC · Ypsilanti, MIBuilt 1978 · S/N 170N870ZPotomac Corp · Wheeling, ILBuilt 2001 · S/N 193N876MRBudget Jet LLC · Greenville, DEBuilt 1994 · S/N 125N8778Ligon Air LLC · Birmingham, ALBuilt 2001 · S/N 258560N877SARegistered aircraftBuilt 1997 · S/N 260N878MBMb Air LLC · New York, NYBuilt 2002 · S/N 258603N87KBKkb Holdings LLC · Wilmington, DEBuilt 2003 · S/N 331N87RTPremier Lj40 Inc · Wilmington, DEBuilt 1977 · S/N 106N880CHEcho Acquisitions LLC · Dover, DES/N 168N880PLExecutive Air Taxi Corp · Bismarck, NDBuilt 1998 · S/N 258380N881AFPetrotransit LLC · Cypress, TXBuilt 1996 · S/N 258289N882SCAti Jet Inc · El Paso, TXBuilt 1984 · S/N 590N884ABJetsteam Aviation Inc · Cheyenne, WYS/N 258097N884BBHf III LLC · Saint Paul, MNBuilt 1987 · S/N 17N886DCLcjna Management LLC · Leesburg, VABuilt 1998 · S/N 177N887SGN45ax LLC · Tulsa, OKBuilt 2001 · S/N 174N888CPN888cp Aviation Corp · Wilmington, DEBuilt 1988 · S/N 31-003N888UPTeam Aero LLC · Shawnee, KSBuilt 1981 · S/N 465-68N889CAGracon Express LLC · Lafayette, COBuilt 2001 · S/N 132N890ACDodson Intenrational Parts Inc · Rantoul, KSBuilt 1983 · S/N 92N890LTLife Time Inc · Chanhassen, MNBuilt 1997 · S/N 19N891SHHulfe Air LLC · Caguas, PRBuilt 1991 · S/N 650-0210N892TXByte Me Transportation Inc · Fort Pierce, FLBuilt 2002 · S/N 258592N894TWD Jm Holdings LLC · Sugar Land, TXBuilt 1981 · S/N 354N897ACoastal Greens Aviation LLC · Myrtle Beach, SCBuilt 1997 · S/N 258326N89TBAir Med Capital LLC · Kissimmee, FLBuilt 1979 · S/N 272N89WABurris D Rob Trustee · Tucson, AZBuilt 1999 · S/N 258420N8TGThunderun Aviation Corp · Glenwood, NYBuilt 1999 · S/N 190N900CQCequel III LLC · Saint Louis, MOBuilt 1998 · S/N 30N900DTega Air LLC · Bend, ORBuilt 1993 · S/N 131N900DMMwm Air LLC · Adrian, MIBuilt 1981 · S/N 358
Back to AD 82-23-03 R1