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.

N667WJConnell Blue LLC · Berkeley Heights, NJBuilt 2004 · S/N 258667N669MDDmc Aviation LLC · Scottsdale, AZBuilt 1992 · S/N 068N669RARoyal Air Freight Inc · Waterford, MIS/N 669N66GESunshine Aero Industries Inc · Crestview, FLBuilt 1980 · S/N 465-28N66VAFranco Plastering Inc · Naples, FLBuilt 1983 · S/N 375N66ZBCharter Equipment Leasing LLC · Bellevue, WABuilt 2004 · S/N 258675N670JDAmber Services Inc · Chicago, ILBuilt 1988 · S/N 45N671MMKmwflight LLC · Wilmington, DEBuilt 1984 · S/N 258014N671RRAircraft Fidelity Corp Trustee · Dover, DEBuilt 1993 · S/N 258244N673HBSigma Equity LLC · San Francisco, CABuilt 2005 · S/N 153N676GHNoll Air LLC · Orlando, FLBuilt 2004 · S/N 258676N67ELWard Ohara Companies LLC · Kansas City, MOBuilt 1995 · S/N 153N67FSBank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N 650-0029N67PWNunya LLC · Irvine, CABuilt 1994 · S/N 248N680JSBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 349N680KTSay Tony S · Oklahoma City, OKBuilt 1981 · S/N 77N682DN682d LLC · Wilmington, DES/N NA0431N686BCDodson International Parts Inc · Rantoul, KSS/N 039N689WTotal Prf LLC · Lewes, DEBuilt 1984 · S/N 650-0045N68CBCracker Barrel Old Country Store Inc · Lebanon, TNBuilt 1999 · S/N 258453N68LMAmerica Aviation LLC · Yuma, AZBuilt 1982 · S/N 100N696JMFalcon Aviation Services LLC · Dallas, TXBuilt 1987 · S/N 28N696RGPecos Bend Royalties Lllp · Midland, TXBuilt 1997 · S/N 265N699BGWord Of Life Christian Center Inc · Darrow, LABuilt 1990 · S/N 082N699GGMcair1 LLC · Duck, NCBuilt 1999 · S/N 182N699MWYahweh Property LLC · Houston, TXBuilt 1999 · S/N 049N69BSDspa LLC · Baton Rouge, LABuilt 2001 · S/N 138N69VHKolob Canyons Air Services Inc · Wilmington, DEBuilt 1982 · S/N 062N6FJFlying Farmer LLC · Wilmington, DEBuilt 1977 · S/N 97N6NRSdi Aviation LLC · Rhinelander, WIBuilt 2004 · S/N 258701N700LWAircraft Resource Center Inc · Lakeville, MNBuilt 1986 · S/N 650-0125N700MHMotor City Aeronautics LLC · Okemos, MIBuilt 1986 · S/N 650-0127N700PGAviation Xx LLC · Wilmington, DEBuilt 2004 · S/N 137N700RRDaxen Logistic LLC · Chino, CABuilt 1978 · S/N NA-0217N700SRMd Jet Aviation Services Inc · Wilmington, DEBuilt 1983 · S/N 079N702SMTeam Aero LLC · Olathe, KSS/N 650-0135N703DJCommercial National Bank Of Brady · Brady, TXBuilt 1977 · S/N 155N704JMCnhi LLC · Montgomery, ALBuilt 1998 · S/N 258367N707CXV1vr LLC · Wilmington, DEBuilt 1988 · S/N 216N707DHKl707dh Investments LLC · Dover, DEBuilt 1998 · S/N 010N707JQPinnacle Aviation Group LLC · Wilmington, DEBuilt 2005 · S/N 258703N709LPPilgrim Air LLC · Van Nuys, CABuilt 1997 · S/N 258329N70AYSmi Air LLC · Wilmington, DEBuilt 1999 · S/N 188N70DTJet Set Aviation LLC · Memphis, TNS/N 334N70LFWind Turbine And Energy Cables Corp · Hasbrouck Heights, NJBuilt 1996 · S/N 09N70PLFalcon 33 LLC · Las Vegas, NVBuilt 1980 · S/N 436N70SKDylan Dublin Air LLC · Hobe Sound, FLBuilt 1980 · S/N 465-33N70TTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 102N710HRAsf Aviation LLC · Cortlandt Manor, NYBuilt 1999 · S/N 258390N710VPTx N710vp LLC · Austin, TXBuilt 1999 · S/N 650-7100
Back to AD 82-23-03 R1