OpenAirDocs.org
AD 77-07-05 R1

Registered aircraft · 221

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

N233WHBank Of Utah Trustee · Salt Lake City, UTBuilt 1979 · S/N 2116N236HAEndries Ryan A · Milwaukee, WIBuilt 1977 · S/N HA3063N239SBSale Reported · Cottage Grove, ORSale reported, pending cancellationBuilt 1956 · S/N 800N245CHansen Christopher H · Durhamville, NYBuilt 1953 · S/N 324N25196Fort Wolters Helicopter Inc · Mineral Wells, TXBuilt 1976 · S/N 101N263SSMadden Russell E · Graford, TXS/N 265N2678YNorthwest Helicopters I Inc · Olympia, WABuilt 1960 · S/N 2048N26PEMshr Helicopter Service LLC · Chehalis, WAS/N 1327N26USPlane Fun Inc Tr Trustee · Snellville, GABuilt 1957 · S/N 823N2770Lil Dawg Aviation · Wilmington, DES/N 1250N28801Knutson Wayne R · Tioga, NDS/N 1218N28908Slikker Flying Service Inc · Buttonwillow, CABuilt 1962 · S/N 1332N2VUUpham Slade C · Fort Worth, TXBuilt 1965 · S/N 1726N307AJSwashbuckle Air LLC · Anchorage, AKBuilt 1952 · S/N 426N3269FYellowjacket Aviation LLC · Wenatchee, WABuilt 1976 · S/N 1144N330MLacy Glenn M · Bedford, VAS/N 287N3324FSummit Sales & Leasing Inc · Salem, VABuilt 1964 · S/N 1735N3351FCarey James D · Winterset, IABuilt 1960 · S/N 1207N33616Sale Reported · Lakeland, FLSale reportedBuilt 1955 · S/N 720N3375TE L Automation Inc · Bonners Ferry, IDS/N 5237N34SDFort Wolters Helicopters Inc · Mineral Wells, TXBuilt 1965 · S/N 1618N36670S & S Landscape Supply Inc · Grand Junction, COBuilt 1960 · S/N 1277N374HDreyer Elwain C · Cardington, OHS/N 1374N3751ZHiller Aviation Inc · Firebaugh, CAS/N 2202N3829Dunn Emet · Coolidge, AZS/N 1425N38763International Air Services Inc Trustee · Carson City, NVS/N 497N38767Pockrus Pat B · Mineral Wells, TXS/N 1037N3877LJarrell Stephen L · Edgewood, NMBuilt 1954 · S/N 674N3978ZFort Wolters Helicopter Inc · Mineral Wells, TXS/N 2106N40277Northwest Helicopters I Inc · Olympia, WABuilt 1979 · S/N 5087N4027DFour Creeks Aviation · Visalia, CAS/N 5072N40290Haddock Flying Service Inc · Salters, SCBuilt 1980 · S/N HA3081N4029SSlikker Flying Service Inc · Buttonwillow, CABuilt 1980 · S/N 5129N4032YBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 5180N40346Rutland Flying Service · Ridge Spring, SCBuilt 1982 · S/N 5192N4035LFour Creeks Aviation Inc · Visalia, CABuilt 1982 · S/N 5199N410NRHaynes Cory W · Heyburn, IDBuilt 1961 · S/N 2244N41319Aspinwall W Frank · Kingsland, GAS/N 433N4254AJames David R · Wayne, MIBuilt 1950 · S/N 229N4277XHigh Country Helicopter LLC · Blowing Rock, NCBuilt 1981 · S/N 5161N430NRRutland Flying Service Inc · Ridge Spring, SCRegistration expired, pending cancellationS/N 2074N440NRMagnum Aviation LLC · Goff, KSBuilt 1964 · S/N 2275N4415Fort Wolters Helicopter Inc · Mineral Wells, TXBuilt 1960 · S/N 2040N469DWBishop Thomas W · Decatur, TXBuilt 1956 · S/N 869N47063Geco Inc · Wilmington, DEBuilt 1962 · S/N 1422N47077Knutson Flying Service Inc · Tioga, NDBuilt 1957 · S/N 947N47242Pockrus Pat B · Mineral Wells, TXBuilt 1952 · S/N 491N4733CTaz Air Service Inc · Middletown, DES/N 260N4785CBorszich Claude C Jr · Phoenix, AZBuilt 1952 · S/N 312N492HSChamberlain Paul E · Troup, TXBuilt 1959 · S/N 1141
Back to AD 77-07-05 R1