OpenAirDocs.org
AD 77-13-08

Registered aircraft · 381

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

N100DRWolfe Stephen Charles · Tulsa, OKBuilt 1976 · S/N TK-2N100HPHinds Community College · Raymond, MSBuilt 1980 · S/N TK-116N1042TJbr Leasing Inc · Orlando, FLBuilt 1976 · S/N TJ-79N105RKEwing John M · Cumming, GABuilt 1979 · S/N TK-104N108LMSkyvista Aviation LLC · Marysville, OHBuilt 1979 · S/N TJ-228N109DWAero East USA LLC · Portage, INBuilt 1976 · S/N TJ13N10NFThompson Benjamin K · Nevada, TXBuilt 1976 · S/N TJ-64N10WPawsitive Rate LLC · Corpus Christi, TXBuilt 1984 · S/N TJ-448N110CWMile High 1 LLC · Lakeway, TXBuilt 1980 · S/N TK-115N114PJRowe John J · Kansas City, MOBuilt 1982 · S/N TJ-410N115WEPhilips Robert Jay · Midlothian, TXBuilt 1976 · S/N TK-15N117RSJa1 Aviation LLC · Sedan, KSBuilt 1979 · S/N TJ-224N121BLOlson Brian D · Las Vegas, NVBuilt 1982 · S/N TJ-413N121GJ424 Ventures LLC · Saint Petersburg, FLBuilt 1976 · S/N TJ-62N123BCBlue River Baron 58 LLC · Malcolm, NEBuilt 1977 · S/N TK-41N124MDKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1981 · S/N TJ374N125LLDykstra Darren · Pacific Grove, CABuilt 1982 · S/N TJ-417N125TCYoung Jeremy · Portland, ORBuilt 1975 · S/N TJ-3N126TKLoftis Chris · Fort Worth, TXBuilt 1980 · S/N TK-126N131MEDuncan John H Jr · Bend, ORBuilt 1984 · S/N TJ-451N134MDAa Aviation LLC · Lewes, DES/N TJ-449N135RWOneal Eric T · Geneva, FLBuilt 1981 · S/N TJ-351N138PBSouth Delta Aviation Inc · West Helena, ARBuilt 1980 · S/N TJ-273N138PLCpg Air LLC · Skaneateles, NYBuilt 1986 · S/N TJ-482N138TLHarvest International Ministries Inc · Texarkana, ARBuilt 1981 · S/N TJ-362N13PECamm Air · Spencer, IAS/N TJ-50N143DSBen-David Meir · Woodland Hills, CABuilt 1981 · S/N TJ-357N146ZUtah State University · Logan, UTBuilt 1982 · S/N TJ-426N147WDDarroh Harold W · Richmond, TXBuilt 1979 · S/N TK-102N14PGorman Aviation LLC · Bartlesville, OKBuilt 1985 · S/N TJ-492N155ZPennsylvania College Of Technology · Williamsport, PABuilt 1981 · S/N TJ-368N156ASkymook Aviation LLC · Beaver Falls, PABuilt 1977 · S/N TK-56N157NNewsome Jeffrey S · Blackwell, OKBuilt 1976 · S/N TJ-52N158KSBowerman Marvin · Montgomery, TXBuilt 1982 · S/N TJ-419N158RSRegistration Pending · Wallace, CARegistration pendingBuilt 1981 · S/N TJ-359N158TCBoyd Brent · Fort Worth, TXBuilt 1978 · S/N TK-68N159ZIdaho State University · Pocatello, IDBuilt 1978 · S/N TJ-178N15JAAdams Harry Jay · New Waverly, TXBuilt 1979 · S/N TK95N15JUC&D Aviation LLC · Appleton, WIBuilt 1982 · S/N TJ-434N15XLrb Aviation LLC · Catawba, NCBuilt 1979 · S/N TJ-226N161ABSafford Aviation Service Inc · Coolidge, AZBuilt 1977 · S/N TJ-122N162DFFaford Aviation Leasing Co · Atherton, CABuilt 1982 · S/N TJ-403N1717SXp Silva Air LLC · Rockaway, NJS/N TJ-53N171DFDkg Motorized Conveyances Inc · Beaverton, ORBuilt 1978 · S/N TJ-155N177DGHesperia Construction Inc DBA · Ramona, CABuilt 1979 · S/N TJ-241N17850Copeland Kenneth E · Rosie, ARBuilt 1977 · S/N TK-58N17ESCrimson Aviation LLC · New York, NYBuilt 1985 · S/N TJ-488N17GPRed River Partners LLC · Edmond, OKBuilt 1979 · S/N TJ-210N1806DGold Coast Logistics LLC · St Simons Island, GABuilt 1981 · S/N TJ-364N1808RFlorida Fence Corp · Tavernier, FLS/N TJ-366
Back to AD 77-13-08