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.

N329TJForsythe Aviation LLC · Point Lookout, MOS/N 120N32HHPhi Health LLC · Tempe, AZBuilt 2000 · S/N 201N32HMAir Mellon LLC · Wilmington, DEBuilt 1983 · S/N 499N32KBS S K Hawker Group LLC · New Haven, CTBuilt 2000 · S/N 258461N331JVBoulder Falcon LLC · Salt Lake City, UTS/N 219N331SKD & E Aviation LLC · Missoula, MTBuilt 1992 · S/N 063N331USN331us LLC · Hillsboro, ORBuilt 2000 · S/N 196N333DLD&S Aircraft LLC · Chicago, ILBuilt 1997 · S/N 163N333KEFalconmitch Inc · Sulphur Springs, TXBuilt 1974 · S/N 14N333PCSemanik Investment Corp · Jacksonville, FLBuilt 2004 · S/N 258669N335KBShelt William J · Denton, TXS/N 588N335PRGy Aircraft LLC · Daytona Beach, FLBuilt 1989 · S/N 647N335RCN335 Aviation Corp · Middletown, DEBuilt 1979 · S/N 256N33612Pmdg Flight Operations LLC · Alexandria, VABuilt 1989 · S/N 196N337WRAer Sales Lp · Carrollton, TXBuilt 1995 · S/N 258273N339AVKmwflight LLC · Wilmington, DEBuilt 1994 · S/N 258255N33APGolden Triangle Aviation LLC · Beaumont, TXBuilt 1981 · S/N 81N33BCSworks Aviation LLC · Chicago, ILBuilt 1996 · S/N 258292N33RCBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 258466N33TRAirborne Holdings Inc · Midlothian, TXBuilt 1980 · S/N 465-47N343WTPhantom Phlyers LLC · Pearland, TXBuilt 1986 · S/N 633911N345MAMed Air LLC · Wilmington, DEBuilt 1999 · S/N 054N345TRJog068 Inc · Lewes, DEBuilt 1981 · S/N 345N348AJE E & K C LLC · New Orleans, LABuilt 1997 · S/N 258334N34TJAbove The Rest Aircraft Services LLC · Midlothian, TXBuilt 1975 · S/N 41N351ASRoyal Air Freight Inc · Waterford, MIBuilt 1977 · S/N 146N351PJPremier Jets Inc · Hillsboro, ORBuilt 1976 · S/N 074N351TXDodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N 127N352CKKalitta Charters LLC · Ypsilanti, MIBuilt 1980 · S/N 313N352EFDodson International Parts Inc · Rantoul, KSBuilt 1992 · S/N 046N353CKKalitta Charters LLC · Ypsilanti, MIBuilt 1976 · S/N 081N353HAMpr Aviation LLC · Wilmington, DEBuilt 1986 · S/N 650-0109N354LQBrunner Aerospace LLC · Georgetown, TXBuilt 1976 · S/N 055N355CKKalitta Charters LLC · Ypsilanti, MIBuilt 1976 · S/N 062N355FAE D Santos & & Associates LLC Trustee · Wilmington, DEBuilt 1989 · S/N 258156N355KCN331us LLC · Hillsboro, ORBuilt 1982 · S/N 490N355RMLopez Fabio A · Denver, NCBuilt 1982 · S/N 033N355UALopez Fabio A · Denver, NCBuilt 1984 · S/N 114N356EJAlliance Aviation Group LLC · Wilmington, DEBuilt 1999 · S/N 258452N356MANazareth Bay Holdings LLC · Palm Beach Gardens, FLBuilt 1998 · S/N 258373N357CKKalitta Charters LLC · Ypsilanti, MIBuilt 1980 · S/N 323N358CKAirnet II LLC · Columbus, OHBuilt 1978 · S/N 210N35AEAmerican Fidelity Corp Trustee · Dover, DES/N 595N35AJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1975 · S/N 010N35CDCoastal Development Group LLC · Boca Grande, FLBuilt 1989 · S/N 224N35LJDelta Bravo LLC · Taylorville, ILBuilt 1979 · S/N 240N35WLKalitta Charters LLC · Ypsilanti, MIBuilt 1981 · S/N 438N361KBpcp Falcon N361k LLC · Wilmington, DES/N 83N361PJPremier Jets Inc · Hillsboro, ORBuilt 1974 · S/N 003N362PJPremier Jets Inc · Hillsboro, ORBuilt 1976 · S/N 017
Back to AD 82-23-03 R1