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.

N58DHAviation Trust Co LLC Owner Trustee · Oklahoma City, OKBuilt 2002 · S/N 258599N58HTAmerican Air Charter Inc · Chesterfield, MOBuilt 1981 · S/N 465-70N590TCLear Holding Corp · Wilmington, DEBuilt 1983 · S/N 082N595DCChoice Aviation LLC · San Antonio, TXBuilt 1990 · S/N 650-0179N595PLFly High Inc · Wichita, KSBuilt 1994 · S/N 97N597AFMoondream 5 LLC · Cypress, TXBuilt 1995 · S/N 650-7057N59CJOptical Air Data Systems LLC · Manassas, VABuilt 1986 · S/N 159N59FTSt Andrews Aircraft LLC · West Palm Beach, FLBuilt 1986 · S/N 650-0123N5CAMach 87 LLC · Sulphur Springs, TXBuilt 1981 · S/N 187N5VGLear Holding Corp · Wilmington, DES/N 014N5XRAviacion Del Oeste Inc · Mayaguez, PRBuilt 1982 · S/N 063N600KEJuliet Zulu Aviation LLC · Loganville, GABuilt 1985 · S/N 416N600RARoyal Air Freight Inc · Waterford, MIBuilt 1984 · S/N 296N603AWNational Test Pilot School · Mojave, CABuilt 1981 · S/N 46572N604GSSix Hundred Four Corp · Paramus, NJS/N 604N604PTR3hd Air LLC · Marietta, GABuilt 1969 · S/N 202N605BXXcel Jet Management Inc · Newark, DEBuilt 2003 · S/N 2004N606WJHawker 800xp LLC · Fort Lauderdale, FLBuilt 2002 · S/N 258606N607RJFlamingo Aircraft Holdings LLC · Orlando, FLBuilt 1990 · S/N 206N609RBAviation Group Jmj Inc · Callahan, FLExpired dealer, pending cancellationBuilt 1984 · S/N 258019N60BTReklaw Management Co · Houston, TXBuilt 1987 · S/N 432N60HXFlying Piggs LLC · Klamath Falls, ORBuilt 1981 · S/N 47N610RLFalconrl LLC · Missoula, MTBuilt 1988 · S/N 68N6110Solidwood Aviation Express LLC · Waller, TXBuilt 1993 · S/N 650-7023N611ATN611at LLC · Punta Gorda, FLBuilt 1987 · S/N 650-0143N611TGRegistered aircraftBuilt 1981 · S/N 55N615FJMegatel Group Services LLC · Dallas, TXS/N 102N616LKMeisner Aircraft Inc · Janesville, WIBuilt 2002 · S/N 240N616WGForza Wings LLC · Laredo, TXBuilt 1985 · S/N 258030N61RARoyal Air Freight Inc · Waterford, MIBuilt 1987 · S/N 630N61SJByrum Lyle Trustee · Roswell, NMBuilt 1983 · S/N 081N61VWSolomon Mark Trustee · Wilmington, DEBuilt 1991 · S/N 049N620KEAir Coryell Flight LLC · Springfield, MOBuilt 2001 · S/N 137N623PMLal Holdings LLC · Gallatin, TNBuilt 1992 · S/N 650-7018N625CYCite Aviation LLC · Wilmington, DES/N 625N626BMRegistered aircraftBuilt 1989 · S/N 634N626HJAv 900 LLC · Deerfield Beach, FLBuilt 1988 · S/N 180N626JCSeascape Air LLC · Irvine, CABuilt 2001 · S/N 140N628EKKauffman Land & Development LLC · Fort Lupton, COBuilt 1982 · S/N 071N629BKKeselowski Transportation LLC · Statesville, NCBuilt 2002 · S/N 198N629EPRockland Aviation LLC · New City, NYBuilt 1982 · S/N 109N629MDAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1985 · S/N 650-0096N62DTN250ap LLC · Chicago, ILS/N 200N62LJN62lj LLC · Fort Lauderdale, FLBuilt 1982 · S/N 056N62RARoyal Air Freight Inc · Waterford, MIS/N 312N632JSRms Flight Services LLC · Wilmington, DEBuilt 1999 · S/N 061N633PJN633pj LLC · Oklahoma City, OKBuilt 2002 · S/N 241N635RJRoyal Air Freight Inc · Waterford, MIBuilt 1975 · S/N 35-017N63FXTrn Aviation LLC · Lewes, DEBuilt 1994 · S/N 6500234N63UCJamrock Leasing LLC · Schenectady, NYBuilt 2001 · S/N 136
Back to AD 82-23-03 R1