AD 77-07-06

Registered aircraft · 361

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-07-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:77-07-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.

N444LPierwest Aviation LLC · Tulsa, OKBuilt 1980 · S/N LW-344N44HPAime High LLC · Lake City, FLBuilt 1976 · S/N LJ-702N45SADavis Aviation Inc · Brandon, MSBuilt 1980 · S/N LJ-903N463RSRts Aviation LLC · Atlanta, GABuilt 1987 · S/N LJ-1143N465TASouthwest Aviation Specialties LLC · Tulsa, OKS/N LJ630N469BUnited States Construction Corporation · Pompano Beach, FLBuilt 1978 · S/N LJ-803N46CVSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1972 · S/N LJ-568N46RPJst Management LLC · Zephyrhills, FLBuilt 1976 · S/N LW-193N46SBDavis Aviation Inc DBA · Brandon, MSS/N LW-312N472EAWashington State Community College · Spokane, WAS/N LW-250N4776MPassion Aviation LLC · Bells, TXBuilt 1978 · S/N LJ-776N477MAircraft Unlimited Inc · Pierre, SDBuilt 1987 · S/N LJ-1154N478CRAlg Aircraft LLC · Delano, CABuilt 1997 · S/N LJ-1474N481ZGalazy Lift II LLC · New York, NYBuilt 1973 · S/N LW-52N484MCLee County Mosquito Control District · Lehigh Acres, FLBuilt 1978 · S/N LJ-807N48AZStover Aviation LLC · Dallas, GABuilt 1979 · S/N LJ-859N48WPlatina Investment Corporation · Oklahoma City, OKBuilt 1977 · S/N LW-254N4947MKca Of Montana LLC · Helena, MTBuilt 1978 · S/N LJ-780N495NMCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1978 · S/N LJ-781N49JPSumner Properties LLC · Somersworth, NHBuilt 1990 · S/N LJ1243N500EQTxsd Holdings LLC · Amarillo, TXBuilt 1994 · S/N LJ-1387N501MSDodson International Parts Inc · Rantoul, KSBuilt 1974 · S/N LJ-626N503CBCtb Inc · Goshen, INBuilt 1982 · S/N LJ-997N504CBPlane Leasing LLC · Wilmington, DEBuilt 1974 · S/N LW-125N505MWBoeing Co · Renton, WAS/N LW-155N506AFCreedeair LLC · San Antonio, TXBuilt 1979 · S/N LJ-843N50EBDavis Aviation Inc · Brandon, MSBuilt 1975 · S/N LW-128N5111PDe La Vega Artemio · Dallas, TXBuilt 1986 · S/N LJ-1136N511WMD&D Industries Inc · Monclova, OHBuilt 1973 · S/N LW-57N515GKAvintel Management LLC · Dublin, OHBuilt 1974 · S/N LW-108N51DNDjl Investments LLC · Gilroy, CABuilt 1972 · S/N LW-7N522MJPpr2 Inc · Jackson, MSS/N LW-80N52KACentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1973 · S/N LW-42N52VSVista Strategies & Solutions Group LLC · Hendersonville, NCS/N LW-301N533SSMacon King Air 90 LLC · Dover, DEBuilt 1976 · S/N LW-197N53CEEngineering And Mfg Svcs Inc · Huntsville, ALBuilt 1975 · S/N LW-160N53ECBas Part Sales LLC · Greeley, COBuilt 1972 · S/N LJ552N53HSC&B Aerial Transport Inc · Wilmington, DEBuilt 1976 · S/N LW-186N546CNCwn LLC · Wilmington, DEBuilt 1974 · S/N LJ609N549BRCentral Virginia Aviation Inc · Petersburg, VABuilt 1978 · S/N LJ-809N54PTMccall Transport LLC · Portland, ORS/N LW-331N552BSBroken Arrow Crop Insurance Inc · Perryton, TXBuilt 1979 · S/N LJ-836N55HCMile High Club Of Texas LLC · El Paso, TXBuilt 1975 · S/N LW-134N55MNMinnesota Department Of Transportation · Saint Paul, MNBuilt 1981 · S/N LJ-974N55WFIcm Inc · Colwich, KSBuilt 1985 · S/N LJ-1114N567GJDavis Aviation Inc DBA · Brandon, MSBuilt 1974 · S/N LW95N569EREastside Rice LLC · Jonesboro, ARBuilt 1981 · S/N LJ-944N56HTLissie 6 LLC · Harlingen, TXFirst renewal noticeBuilt 1977 · S/N LW-215N575CLilly David E · Allentown, PABuilt 1971 · S/N LJ-532N580RAGibson & Harrup Leasing LLC · North Dinwiddie, VABuilt 1973 · S/N LJ-580
Back to AD 77-07-06