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.

N307DLNova Jets USA Corp · Orlando, FLS/N 2002N307XPSkybridge Aviation Group Inc · Apopka, FLBuilt 1996 · S/N 258307N308DD225sbi LLC · Stuart, FLBuilt 2004 · S/N 258665N308MRStonegate Holdings LLC · San Antonio, TXBuilt 1988 · S/N 650-0153N30AXN27ax LLC · Tulsa, OKBuilt 2001 · S/N 141N30LJWorldwide Aircraft Services Inc · Tampa, FLBuilt 1988 · S/N 002N30MRBergen Food Enterprises Inc · Norman, OKBuilt 1978 · S/N 225N30TEV1vr LLC · Wilmington, DEBuilt 1980 · S/N 152N30TKGravitas Aero LLC · Dallas, TXBuilt 1982 · S/N 374N310LJTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 031N310ZAZair Force One LLC · Mendenhall, MSBuilt 1987 · S/N 009N311BPWls Enterprise LLC · Portland, ORBuilt 2001 · S/N 314N311FLAlliance Aviation Group LLC · Wilmington, DEBuilt 1997 · S/N 258338N311KBJet Plaid LLC · Nashville, TNBuilt 2004 · S/N 135N311RSKen Sale Resources Inc · Southlake, TXBuilt 1977 · S/N 5222N312FUKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2001 · S/N 258545N312LGJet Masters LLC · Englewood, COBuilt 1982 · S/N 489N312STexas Aircraft Parts Brokers LLC · Seguin, TXBuilt 1999 · S/N 258436N312WMWoodhill Aviation Corp · Elk Grove Village, ILBuilt 1991 · S/N 224N314SGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1997 · S/N 133N314TCTop Cat Aviation LLC · Pelham, ALBuilt 1999 · S/N 258400N315RCRocklyn National LLC · Syracuse, NYBuilt 2000 · S/N 258480N315SCInternational Skychase Corp · Alachua, FLBuilt 1982 · S/N 130N316CLCalco 316 LLC · Frisco, TXBuilt 1993 · S/N 6507032N316TDBas Part Sales LLC · Greeley, COBuilt 1980 · S/N 312N3170BSpring Mountain Enterprises Inc · Corvallis, ORS/N 650-0136N317CQPrivate Fliers LLC · Wheaton, ILBuilt 2001 · S/N 258532N317TTInter Island Yachts Inc · Zephyr Cove, NVBuilt 1980 · S/N 317N318NWMed Jets USA Inc · Boca Raton, FLBuilt 1980 · S/N 318N31DTFa31dt LLC · Owasso, OKBuilt 1997 · S/N 147N31GJGlobal Jetcare Inc · Brooksville, FLBuilt 1976 · S/N 022N31KHAery Aviation LLC · Wilmington, DEBuilt 1999 · S/N 173N31LJDelta November LLC · Lewes, DEBuilt 1994 · S/N 097N31RARoyal Air Freight Inc · Waterford, MIBuilt 1979 · S/N 288N31YAInternational Trading Energy Fuels LLC · Houston, TXBuilt 1990 · S/N 021N31ZVEzair International Leasing And Management Inc · Wilmington, DEBuilt 1996 · S/N 127N31ZZE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1989 · S/N NA0437N320EJAlliance Aviation Group LLC · Wilmington, DEBuilt 2001 · S/N 258523N320MDIsland Jet Aviation Inc · Lewes, DENon-citizen corporation, flight hours not reportedBuilt 1981 · S/N 366N321MSTaughannock Aviation Corp · Ithaca, NYBuilt 2001 · S/N 258515N322GC1mg LLC · Fort Wayne, INBuilt 1990 · S/N 142N322PRN322pr LLC · Scottsdale, AZBuilt 1991 · S/N 038N323AAE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1989 · S/N 258155N325EXFalcon 325 LLC · Fort Pierce, FLBuilt 2002 · S/N 325N325JFN325jf Operating LLC · Dallas, TXBuilt 1990 · S/N 6500181N325NWKalitta Charters LLC · Ypsilanti, MIBuilt 1980 · S/N 325N325RDLow Tide LLC · Riverside, IABuilt 1995 · S/N 650-7056N327GALmi LLC · Alpharetta, GABuilt 2005 · S/N 157N328JLLamon Aviation LLC · Boise, IDBuilt 1996 · S/N 157N328PCSn 328 Corp · Fort Lauderdale, FLS/N 328
Back to AD 82-23-03 R1