AD 97-06-06

Registered aircraft · 2,038

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:97-06-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-06-06')
  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.

N175SAGeneral Atomics · San Diego, CABuilt 1976 · S/N BB-183N176JRKimmel Aviation Insurance Agency Inc · Greenwood, MSBuilt 1974 · S/N LW-115N176LABallard Aviation Inc · Newton, KSBuilt 1983 · S/N LA-210N176MRegent Trust Corp Trustee · Wichita, KSBuilt 1982 · S/N BB-1029N176TWSierra American Corporation · Wilmington, DEBuilt 1974 · S/N LW-76N176YVHill Air Executive Inc · Fort Pierce, FLBuilt 1995 · S/N UE-176N177CNRca Aviation 2 LLC · Tempe, AZBuilt 1984 · S/N BB-1191N177LACabeza De Vaca Holdings LLC · Carrollton, TXBuilt 1985 · S/N BB1203N177MKTrans Equipment Svcs Inc · Greenville, SCBuilt 1975 · S/N LW-149N17812Best Aircraft Deals LLC · Salt Lake City, UTS/N BB236N178LAPonca International LLC · Bentonville, ARBuilt 1982 · S/N LA-178N178YVAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-178N179MDGem City Properties LLC · Laramie, WYS/N LJ-1091N17EHSystem Packaging Co Inc · Bell, CABuilt 1986 · S/N BB1257N17KKRiverbend Aviation LLC · Hernando, MSBuilt 1998 · S/N LJ-1318N17NMCentral Virginia Aviation Inc · Petersburg, VABuilt 1977 · S/N LW-237N17VAOptimal Aviation Services LLC · Visalia, CABuilt 1980 · S/N BB-670N17WGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N BB-1602N1801BSjd Flight LLC · Houston, TXBuilt 1974 · S/N LJ-634N182CASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N LA-121N183SADriscoll David A · Savannah, TNBuilt 1973 · S/N LJ571N18471Chase Air LLC · Montgomery, ALBuilt 1981 · S/N LA-161N1848ST&T Air LLC · Lindsay, OKBuilt 1996 · S/N LJ-1455N184TXZms Aviation LLC · Wilmington, DEBuilt 1985 · S/N BB-1241N184UXAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-184N1857F56 Express LLC · Willmar, MNBuilt 1981 · S/N LA-167N185MVSouthwest Aviation Inc Div · Marshall, MNBuilt 1982 · S/N BB-1034N187ALAlm Holdings Delaware 2 LLC · Wilmington, DES/N LJ842N187MRJcs Air LLC · Auburn, ALS/N BB-873N188ALAlm Holdings Delaware 3 LLC · Wilmington, DES/N BB-111N188LLTriple Aviation LLC · San Leon, TXBuilt 1981 · S/N BE-119N189ALAlm Holdings Delaware 4 LLC · Wilmington, DES/N BL32N189APRegistered aircraftBuilt 1975 · S/N BB-59N189WAAmeriflight LLC · Dallas, TXBuilt 1969 · S/N U-76N18AFN220pb LLC · Mesa, AZBuilt 1994 · S/N BB-1497N18CMEdgewater Aviation LLC · Guntersville, ALFirst renewal noticeBuilt 1984 · S/N LA-219N18KATreetoppers II LLC · Newark, DEBuilt 1978 · S/N BB-360N18MYWorld Aircraft Leasing Inc · Wilmington, DEFirst renewal noticeS/N LJ562N18SFD&D Maintenance LLC · Etna Green, INBuilt 1985 · S/N LA236N1902DBoeing Co · Berkeley, MOBuilt 1998 · S/N UE327N190AWCsi 135 Division LLC · Albuquerque, NMBuilt 1999 · S/N UE-382N190BETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1981 · S/N LW-345N190BHJourney Aviation LLC · Brookland, ARBuilt 1981 · S/N BB-907N190EBKar King LLC · Huntington, WVBuilt 2005 · S/N BB-1905N190EFTriple E Farms LLC · Pasco, WABuilt 1985 · S/N LJ-1122N190FDOreh Aircraft LLC · New Braunfels, TXBuilt 1980 · S/N LA-42N190GAAlpine Aviation Inc · Provo, UTBuilt 1984 · S/N UB-1N190JPClearwater Midstream LLC · Lubbock, TXBuilt 1981 · S/N LA-158N190NCCf Holdings LLC · Hernando, MSBuilt 1982 · S/N LA193N190PMPlanemasters Ltd · West Chicago, ILBuilt 1986 · S/N UB66
Back to AD 97-06-06