AD 80-07-05

Registered aircraft · 429

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:80-07-05')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-07-05')
  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-183N176LABallard Aviation Inc · Newton, KSBuilt 1983 · S/N LA-210N176MRegent Trust Corp Trustee · Wichita, KSBuilt 1982 · S/N BB-1029N177CNRca Aviation 2 LLC · Tempe, AZBuilt 1984 · S/N BB-1191N17812Best Aircraft Deals LLC · Salt Lake City, UTS/N BB236N178LAPonca International LLC · Bentonville, ARBuilt 1982 · S/N LA-178N17VAOptimal Aviation Services LLC · Visalia, CABuilt 1980 · S/N BB-670N182CASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N LA-121N18471Chase Air LLC · Montgomery, ALBuilt 1981 · S/N LA-161N1857F56 Express LLC · Willmar, MNBuilt 1981 · S/N LA-167N187MRJcs Air LLC · Auburn, ALS/N BB-873N188ALAlm Holdings Delaware 3 LLC · Wilmington, DES/N BB-111N189ALAlm Holdings Delaware 4 LLC · Wilmington, DES/N BL32N189APRegistered aircraftBuilt 1975 · S/N BB-59N189WAAmeriflight LLC · Dallas, TXBuilt 1969 · S/N U-76N18CMEdgewater Aviation LLC · Guntersville, ALFirst renewal noticeBuilt 1984 · S/N LA-219N18KATreetoppers II LLC · Newark, DEBuilt 1978 · S/N BB-360N18SFD&D Maintenance LLC · Etna Green, INBuilt 1985 · S/N LA236N190ACGaines Carlo · Broomfield, COBuilt 1973 · S/N 140784N190FDOreh Aircraft LLC · New Braunfels, TXBuilt 1980 · S/N LA-42N190JPClearwater Midstream LLC · Lubbock, TXBuilt 1981 · S/N LA-158N190NCCf Holdings LLC · Hernando, MSBuilt 1982 · S/N LA193N191WAAmeriflight LLC · Dallas, TXBuilt 1970 · S/N U136N1924TUas Transervices Inc · Boca Raton, FLBuilt 1969 · S/N U-115N1926A1926a LLC · Auburn, ALBuilt 1981 · S/N BB-922N192WAAmeriflight LLC · Dallas, TXBuilt 1973 · S/N U152N197WAAmeriflight LLC · Dallas, TXBuilt 1970 · S/N U-130N199BCAirco King LLC · Wichita Falls, TXBuilt 1980 · S/N LA-30N199CZN199cz LLC · Milwaukee, WIBuilt 1968 · S/N U-30N1HXCentralav LLC · Lake Worth, FLBuilt 1978 · S/N BB-361N1MARegistered aircraftS/N LA-3N200ANAirtrex Registration Corp Trustee · Wichita, KSBuilt 1979 · S/N BJ-3N200BTMid-South Regional Aviation LLC · Tunica, MSBuilt 1977 · S/N BB-293N200GWNogottie Landing Co LLC · Amarillo, TXBuilt 1979 · S/N BB-568N200JLCrest Trading Company · Bakersfield, CABuilt 1975 · S/N BB-40N200PZBeech Transportation Inc · Eden Prairie, MNBuilt 1978 · S/N BB-410N200VAVargus Group Inc · Providence, RIBuilt 1977 · S/N BB-246N200WXMorales J Mark Trustee · Corpus Christi, TXBuilt 1979 · S/N BB-680N200ZZAirtrex Aircraft Charlie Inc · Wichita, KSBuilt 1979 · S/N BC-64N203TASouthwest Aviation Specialties LLC · Tulsa, OKS/N BB-658N204TPW & W Innovative Enterprises LLC · Douglas, GABuilt 1976 · S/N BB-115N206PRidgeaire Inc · Jacksonville, TXBuilt 1979 · S/N BB-466N208BCOutside In Aviation LLC · Fort Madison, IABuilt 1975 · S/N BB89N208FDelaware Baron Leasing Partners LLC · Wilmington, DEBuilt 1981 · S/N BB-851N20AEButler Aviation Inc · Houma, LABuilt 1981 · S/N BB827N20FWUas Transervices Inc · Boca Raton, FLBuilt 1969 · S/N U-111N213PHPyro Shows Equipment LLC · La Follette, TNBuilt 1979 · S/N BB-486N214SBSan Bernardino Co Sherriffs Dept · San Bernardino, CABuilt 1975 · S/N BC-02N217CMKlas-Kcoe LLC · Las Vegas, NVBuilt 1980 · S/N BB-621N217MLDodson Intl Parts Inc · Rantoul, KSS/N BB739
Back to AD 80-07-05