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.

N50HNN45zf LLC · Wilmington, DEBuilt 1985 · S/N 153N50KDPw Transport LLC · Lafayette, LABuilt 1985 · S/N 145N50KLLiberty Leasing V LLC · Melbourne, FLBuilt 2004 · S/N 258671N50LJWorldwide Aircraft Services Inc DBA · Tampa, FLBuilt 2000 · S/N 205N50NMN50nm LLC · Dover, DEBuilt 1997 · S/N 266N50SNFirst Quality Falcon LLC · Great Neck, NYBuilt 2000 · S/N 310N50SQCfwm LLC · Destin, FLBuilt 1986 · S/N 147N50TW17 Aviation LLC · Oklahoma City, OKBuilt 1999 · S/N 650-7097N50XYPb Tri-Jet LLC · Wilmington, DEBuilt 1982 · S/N 83N50YPVillages Equipment Co · Leesburg, FLBuilt 2005 · S/N 344N510MPPark Avenue Aircraft Trust LLC Trustee · Dover, DEBuilt 1984 · S/N 140N510SDChg Jets LLC · Orange, CABuilt 1988 · S/N 650-0161N511JCIntermodal Air LLC · Frankfort, ILBuilt 2001 · S/N 258518N511KDBank Of Utah Trustee · Salt Lake City, UTBuilt 1994 · S/N 088N511RSVmrfalcon50 LLC · Evans, GAS/N 154N5123Tpi Aircraft Interiors LLC · New Bern, NCBuilt 1984 · S/N 123N513BEH800 IV LLC · Stuart, FLBuilt 2000 · S/N 258471N513SKHappy Skies LLC · Dover, DEBuilt 2004 · S/N 338N513TSGully Air LLC · College Station, TXBuilt 1999 · S/N 650-7096N514MBMcl Falcon LLC · Chicago, ILBuilt 1986 · S/N 168N515CSCasavia Corp · Wilmington, DEBuilt 1999 · S/N 185N515CYPacwest Aerodyne LLC · Tualatin, ORS/N 028N516MXBank Of Utah Trustee · Salt Lake City, UTBuilt 1996 · S/N 079N516THHippo Air LLC · Grants Pass, ORBuilt 1999 · S/N 258418N518SBGba Legacy LLC · Hopkins, MNBuilt 1979 · S/N 139AN519EMMid-South Investments LLC · Magnolia, ARBuilt 1980 · S/N 19N51FNGh Equipment LLC · Dover, DEBuilt 1976 · S/N 069N51JVSky Global LLC · San Juan, PRBuilt 1984 · S/N 650-0050N520CKLancaster Travel And Leisure Inc · Lancaster, PABuilt 1997 · S/N 094N520TCDodson International Parts Inc · Rantoul, KSS/N 319N521FLIfl Group Inc · Waterford, MIBuilt 1967 · S/N 68N521JKSale Reported · Beverly Hills, CASale reported, canceledBuilt 1994 · S/N 258262N526SMLucken LLC · Kalispell, MTS/N 201N527PAPhoenix Air Group Inc · Cartersville, GABuilt 1976 · S/N 019N527SRedleaf Management Company LLC · Miami, FLS/N 8N528LButler National Inc · Olathe, KSS/N 528N530SEHill Country Jet Partners LLC · Spicewood, TXBuilt 1981 · S/N 454N534HHec Aviation LLC · Shelbyville, TNBuilt 1991 · S/N 650-0196N535PSTeam Aero LLC · Olathe, KSBuilt 1999 · S/N 087N537XX945hc LLC · Cypress, TXS/N 2022N53BCDttb LLC · Memphis, TNBuilt 2004 · S/N 152N53HJVentura Aviation Inc · Farmingdale, NYBuilt 1982 · S/N 037N540PAPhoenix Air Group Inc · Cartersville, GABuilt 1977 · S/N 101N541FLIfl Group Inc · Waterford, MIBuilt 1966 · S/N 48N541RLBj Aviation LLC · Anchorage, AKBuilt 1989 · S/N 034N541SRider Terry · Corinth, MSBuilt 1986 · S/N 6500115N542LMAero Air LLC · Hillsboro, ORBuilt 1980 · S/N 35A-280N542WCHmv Aviation LLC · Elizabethton, TNBuilt 1990 · S/N 044N543LMMarklyn Jet Parts LLC · Dallas, TXBuilt 1981 · S/N 426N544LMCorsair Two LLC · Hillsboro, ORBuilt 1983 · S/N 500
Back to AD 82-23-03 R1