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.

N63WJKaylan Paige Leasing LLC · Grand Junction, COBuilt 2005 · S/N 278N63YMSun Country Products LLC · Tampa, FLBuilt 2003 · S/N 258636N640RBTalfin Leasing II LLC · Heflin, ALBuilt 1998 · S/N 650-7092N644CKKalitta Charters LLC · Ypsilanti, MIBuilt 1988 · S/N 644N649TTTownes Aircraft Sales LLC · Paris, TXBuilt 2005 · S/N 342N64HAJoe Air LLC · Sellersburg, INBuilt 1999 · S/N 258448N64MJM J Electric LLC · Iron Mountain, MIBuilt 2001 · S/N 136N64NBRcc Management & Aviation LLC · Magnolia, TXS/N 065N650AHNice Trip LLC · San Juan, PRBuilt 1987 · S/N 650-0139N650CBSzucs Attila · Port Orange, FLBuilt 1985 · S/N 650-0084N650CGC G Bretting Manufacturing Co Inc · Ashland, WIBuilt 1984 · S/N 6500023N650CZTeam Aero LLC · Shawnee, KSBuilt 1995 · S/N 650-7050N650FCOrion Igv LLC · Opa-Locka, FLBuilt 1987 · S/N 650-0146N650GCBank Of Utah Trustee · Salt Lake City, UTBuilt 1992 · S/N 650-0215N650HGHamlin Aviation LLC · Ormond Beach, FLBuilt 1985 · S/N 6500083N650JAAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1985 · S/N 650-0090N650JLEncore Jet Management LLC · San Antonio, TXBuilt 1999 · S/N 650-7101N650JSEwi Tn LLC · Gallatin, TNS/N 216N650KPJt95 Airways LLC · Concord, CABuilt 1985 · S/N 650-0095N650MGFalco Industries LLC · Belle Chasse, LABuilt 1978 · S/N 387N650PFAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1988 · S/N 650-0154N650PJSouthwest Aviation Inc · Marshall, MNBuilt 1995 · S/N 650-7059N650PTBurkim LLC · Hartland, WIBuilt 1989 · S/N 650-0169N650RARomeo Alpha LLC · Addison, TXBuilt 1995 · S/N 650-7047N650RPRussell Air LLC · Madison, INBuilt 1988 · S/N 650-0157N650RTGlobal Aero Aviation Inc · Houston, TXBuilt 1985 · S/N 650-0089N650SFBas Part Sales LLC · Greeley, COBuilt 1984 · S/N 650-0034N650SGMerlin One Aircraft LLC · San Antonio, TXBuilt 1990 · S/N 6500191N650TASale Reported · Greeley, COSale reported, pending cancellationBuilt 1985 · S/N 650-0088N650TWKwafr LLC · Richland Hills, TXBuilt 1997 · S/N 650-7082N650WAWings Aloft Incorporated · Portland, ORS/N 650-0047N651CCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 650-7119N651EJComprehensive Energy Aviation LLC · Longwood, FLBuilt 1995 · S/N 650-0241N651EMWv Jet Experience LLC · Charleston, WVBuilt 1984 · S/N 650-0030N651MKMaxfly Aviation Inc · Fort Lauderdale, FLBuilt 1981 · S/N 465-73N651SFN444cw Partners LLC · Spring, TXBuilt 1984 · S/N 650-0063N652CCSu-N16 LLC · Oak Creek, WIBuilt 1999 · S/N 650-7107N653CCRegistered aircraftBuilt 2000 · S/N 650-7116N653FJDwts LLC · Powder Springs, GAS/N 110N654CPN654cj LLC · Williamsburg, VAS/N 113N655MDMargarita Flights LLC · Longwood, FLBuilt 2004 · S/N 258655N655PEDunbar Aviation LLC · West Kingston, RIBuilt 1982 · S/N 199N655TCTlc Aircraft Leasing LLC · Vero Beach, FLBuilt 2002 · S/N 195N657DJCastiron 5 LLC · Wilmington, DEBuilt 1983 · S/N 094N65MLBae Systems Technology Solutions & Services Inc · Mojave, CABuilt 1981 · S/N 465-69N660PAFriendly Aviation LLC · Dallas, TXBuilt 1993 · S/N 650-0230N663TWButler National Inc · New Century, KSBuilt 1990 · S/N 35A-662N664MMAquarius Aircraft Leasing LLC · Nashville, TNBuilt 1984 · S/N 650-0037N666KLWj Of Delaware Inc · Fort Lauderdale, FLS/N 040N667HFBd Plane Inc · Chicago, ILBuilt 1987 · S/N 25
Back to AD 82-23-03 R1