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.

N816LCMarklyn Jet Parts LLC · Dallas, TXBuilt 1980 · S/N 291N816LJAlliance Aviation Group LLC · Wilmington, DEBuilt 1998 · S/N 011N817EMCentennial Capital LLC · Centennial, COBuilt 1982 · S/N 486N817SDSea Aviation Holdings LLC · Wilmington, DEBuilt 2005 · S/N 258709N818DEMt Gilead Full Gospel International Ministries Inc · North Chesterfield, VABuilt 1987 · S/N 650-0121N818LXN818lx LLC · Wilmington, DEBuilt 2001 · S/N 258534N818WBNext Wave Aviation LLC · Henderson, NVBuilt 1997 · S/N 091N81GJGlobal Jetcare Inc · Brooksville, FLBuilt 1981 · S/N 047N81RARoyal Air Freight Inc · Waterford, MIBuilt 1982 · S/N 472N81VNChromed In Hollywood Inc · Franklin, TNBuilt 1989 · S/N 652N820CKKalitta Charters LLC · Ypsilanti, MIBuilt 1967 · S/N 120N822RLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 258643N823AMAirmed International LLC · Birmingham, ALBuilt 2004 · S/N 258687N823HLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 2037N824CCLg & Gs Holdings II LLC · Middletown, DEBuilt 1982 · S/N 55-024N824CKKalitta Charters LLC · Ypsilanti, MIBuilt 1977 · S/N 124N824MGAti Jet Inc · El Paso, TXBuilt 1984 · S/N 106N825JWT & C Aviation LLC · Temecula, CAS/N 217N825LJRoyal Air Freight Inc · Waterford, MIBuilt 1983 · S/N 496N825QTKjm Air LLC · Aurora, ILBuilt 2000 · S/N 258497N825UWConcept Jet Services Inc · Gainesville, FLBuilt 1985 · S/N 650-0082N825WKMadunn El LLC · Wayzata, MNBuilt 1980 · S/N 025N826CALear Management LLC · Tulsa, OKBuilt 2002 · S/N 222N826GCMqe LLC · Missoula, MTBuilt 1994 · S/N 258263N828MLWalkabout Air Inc · Tampa, FLBuilt 1997 · S/N 25N82RSFly Mda Aviation LLC · Opa Locka, FLBuilt 1997 · S/N 258336N830DMWord Of Life World Outreach Center Inc DBA · Murrieta, CABuilt 1991 · S/N 222N831LXM&N Equipment LLC · Englewood, COBuilt 2000 · S/N 258510N831PC505sj LLC · Jackson, TNBuilt 2001 · S/N 140N831RWHigher Purpose LLC · Ellisville, MOBuilt 1985 · S/N 160N831VPAlana 650 Aircraft LLC · Waterford, MIBuilt 1990 · S/N 650-0194N834AFFenair LLC · Toledo, OHBuilt 2001 · S/N 225N835MCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1992 · S/N 673N83FJCj Aviation LLC · Kalispell, MTBuilt 1981 · S/N 74N83FNGh Equipment LLC · Dover, DEBuilt 1975 · S/N 007N840BMJsj LLC · Wilmington, DEBuilt 2000 · S/N 650-7118N840SWN840sw LLC · Vero Beach, FLBuilt 1994 · S/N 084N841MSSafari Intl LLC · Lewes, DEBuilt 1984 · S/N 650-0056N841TFRoyal Air Freight Inc · Waterford, MIBuilt 1981 · S/N 416N845BBN845bb Partners LLC · Richmond, VABuilt 2000 · S/N 650-7115N845TXButler Brian S · Oklahoma City, OKBuilt 1981 · S/N 342N848NAsf Aviation LLC · Cortlandt Manor, NYBuilt 1998 · S/N 258371N84JHFlycarolina LLC · Concord, NCBuilt 1984 · S/N 650-0062N84TJUsaircraft Inc · Newark, DES/N 188N84UPN84up LLC · Wilmington, DEBuilt 2000 · S/N 258484N850BWJetcorp LLC · Fontana, CABuilt 1982 · S/N 75N850CCSunshine Aero Industries Inc · Crestview, FLBuilt 1980 · S/N 465-38N850ENBcbg Capital LLC · Clearwater, FLBuilt 2002 · S/N 326N850FJPachy Music Corp · Bellflower, CABuilt 1991 · S/N 215N850RARoyal Air Freight Inc · Waterford, MIBuilt 1988 · S/N 189
Back to AD 82-23-03 R1