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.

N740TFTop Gun Air LLC · Pompano Beach, FLBuilt 2000 · S/N 074N744ARTop Air Texas LLC · Glendale, CABuilt 2001 · S/N 316N745MCMiradair LLC · Lake George, NYBuilt 2002 · S/N 258593N745TTFlaghill LLC · Key West, FLBuilt 2000 · S/N 099N746ARJdm Aircraft LLC · Arlington, TXS/N 63N747BWOxford LLC · Fort Lauderdale, FLBuilt 1984 · S/N 594N747CPRoyal Air Charter LLC · El Cajon, CABuilt 1983 · S/N 502N7490ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1982 · S/N NA 0320N750CKMn Aircraft LLC · San Juan, PRBuilt 1992 · S/N 650-7015N751JCCbr Aviation LLC · Delaware, OHBuilt 2001 · S/N 134N752JCTeam Aero LLC · Shawnee, KSBuilt 1980 · S/N 28N757TRRegistered aircraftS/N 560-0598N75ABRivers Equipment III LLC · Nashville, TNBuilt 2001 · S/N 94N75JMJast Air LLC · Wilsonville, ORBuilt 2001 · S/N 123N75MVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 274N75VCSunshine Aero Industries Inc · Crestview, FLBuilt 1981 · S/N 465-71N75XPRedd Air LLC · Vancouver, WABuilt 2000 · S/N 118N760RARoyal Air Freight Inc · Waterford, MIBuilt 1980 · S/N 432N762MG1mg LLC · Fort Wayne, INBuilt 1982 · S/N 035N766HKDac Acquisition Co LLC · Easton, MDBuilt 1985 · S/N 161N766RARoyal Air Freight Inc · Waterford, MIBuilt 1977 · S/N 360N76CDBankair Inc · West Columbia, SCS/N 093N76CKKalitta Charters LLC · Ypsilanti, MIBuilt 1976 · S/N 076N770CCTaughannock Aviation Corp · Ithaca, NYBuilt 2002 · S/N 258587N770FGHangar LLC · Las Vegas, NVBuilt 1967 · S/N 116N777BLBlackstone Mm Assets LLC · Beverly Hills, CABuilt 1990 · S/N 048N777CJHarvest International Ministries Inc · Texarkana, ARBuilt 1986 · S/N 650-0122N777FCAlghazzawi Hani · Holland, OHBuilt 1986 · S/N 508N777MXAirplane III LLC · Fulshear, TXBuilt 1984 · S/N 650-0051N777QLMed Air LLC · Lawrenceville, GABuilt 2002 · S/N 216N777XYCair Leasing LLC · Wilmington, DEBuilt 1987 · S/N 27N77HFCb Aircraft Inc · Fort Lauderdale, FLBuilt 1994 · S/N 650-7036N77LXWatford Horizons LLC · College Station, TXBuilt 1995 · S/N 650-7051N77METrilogy Investments Ag LLC · Las Vegas, NVBuilt 1982 · S/N 96N77SFSeneca Foods Corp · Penn Yan, NYBuilt 1996 · S/N 650-7072N780DWBemo23 Assembly LLC · New York, NYBuilt 1998 · S/N 258378N783FSFarspo LLC · Oklahoma City, OKBuilt 1976 · S/N 09N784AMBank Of Utah Trustee · Salt Lake City, UTBuilt 1995 · S/N 106N786CCPoema Ventures LLC · Chatsworth, CABuilt 2000 · S/N 095N787CVRowley Aviation Inc · Fort Lauderdale, FLBuilt 1994 · S/N 650-7037N789HAClark County Jets LLC · Sellersburg, INBuilt 1998 · S/N 258354N789SRBank Of Utah Trustee · Salt Lake City, UTBuilt 1993 · S/N 083N78MBV1vr LLC · Wilmington, DEBuilt 1977 · S/N 363N790JRTransenergie Inc · Houston, TXBuilt 1984 · S/N 424N791CPMaxus Capital Group LLC · Cleveland, OHBuilt 1982 · S/N 108N793RCLfg Aviation Holdings LLC · Kalispell, MTBuilt 2001 · S/N 258550N795FMCypress Aircraft Sales LLC · Clermont, FLS/N 228N798PAJli Holdings Group Inc · Johns Island, SCS/N 258070N799MWSabre 42 Inc · Lewes, DEBuilt 1980 · S/N 465-42N799RMBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 258708
Back to AD 82-23-03 R1