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.

N493BNStimart Rene D Trustee · Harshaw, WIBuilt 1962 · S/N 1321N4977EWyllie Ashton R J Trustee · Thornton, NHBuilt 1951 · S/N 254N49983Pockrus Pat B · Mineral Wells, TXS/N 850N5025JAnderson Mike DBA · Muskogee, OKS/N 726N504HAEastern Stearman Inc Trustee · Leesburg, VAS/N 5004N5072RFogelson Robert A · Benton City, WAS/N 613N5098YMachacek Kenneth DBA · Midland, TXBuilt 1978 · S/N 5031N5104VOutka Wade R · Aberdeen, SDBuilt 1963 · S/N JR-1N513HAMagnum Aviation LLC · Goff, KSBuilt 1977 · S/N 5013N514HAMagnum Aviation LLC · Goff, KSBuilt 1976 · S/N 5014N518HAClassic Helicopters LLC · Choteau, MTBuilt 1977 · S/N 5018N5301VVrem Kelly L · Sutton, AKBuilt 1953 · S/N 563N5306VDonnelly Matthew J · Romulus, NYS/N 632N5311VBotello Michael C · Rancho Mirage, CABuilt 1955 · S/N 703N5315VSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1956 · S/N 757N5317VInternational Air Services Inc Trustee · Carson City, NVBuilt 1956 · S/N 768N5320VAlbertson James M · Slocomb, ALBuilt 1956 · S/N 786N5321VGates Steven · Midlothian, TXBuilt 1956 · S/N 822N5325VBouschor William V · Curtis, WABuilt 1959 · S/N 954N5326VJstream Lc · Sheridan, WYBuilt 1956 · S/N 865N5330VMiami Helicopter Services Corp · Miami, FLBuilt 1959 · S/N 1042N535HASummit Helicopters Inc · Salem, VABuilt 1977 · S/N 5035N5362VSale Reported · Xxx, OKSale reportedS/N 2050N5363VEvergreen Avn & Space Museum & The Capt Michael · Mcminnville, ORBuilt 1960 · S/N 2049N5374VBank Of Utah Trustee · Salt Lake City, UTBuilt 1961 · S/N 2073N5381VNorthwest Helicopters LLC · Olympia, WAS/N 2080N538ACHardy John S · Fort Worth, TXBuilt 1953 · S/N 538N543HAMagnum Aviation LLC · Goff, KSBuilt 1978 · S/N 5043N54594Wagner Leslie P · Indian Lake, NYS/N 873N552DRMussche Roger H · Lafayette, INBuilt 1956 · S/N 562261N57CDCarey James Dean · Winterset, IABuilt 1957 · S/N 878N57FDFort Wolters Helicopter Inc · Mineral Wells, TXS/N 817N57PDJ R Trucking & Rigging Inc · Pottsville, PABuilt 1956 · S/N 763N57UPatten Jeffery D · Rapid City, SDS/N 286N58BABank Of Utah Trustee · Salt Lake City, UTBuilt 1957 · S/N 969N6006KSummit Helicopters · Salem, VAS/N HA3083N6032ESummit Helicopters Inc · Salem, VABuilt 1996 · S/N 5232N613HLHood Paul D · Broken Arrow, OKS/N 283N6145GChamberlain Khaythan · Lodi, CABuilt 1982 · S/N 5177N61779Rutherford County Air Rescue Squad · Rutherfordton, NCS/N 779-GSN62171Coyne Patrick J · Tuam Co GalwayNon-citizen corporation, flight hours not reportedS/N GF-2N62275Selzer Robert S · Anchorage, AKS/N 420N62329Puch Len D · New Boston, MIS/N 558N62347Dechene Corp · Big Lake, MNBuilt 1961 · S/N 1247N62361Horizon Helicopters LLC · Toms River, NJBuilt 1975 · S/N 1067N62372Classic Helicopters LLC · Choteau, MTBuilt 1960 · S/N 1229N62392Crawford James B Jr · Salmon, IDBuilt 1964 · S/N 1591N62455Fort Wolters Helicopter Inc · Mineral Wells, TXBuilt 1962 · S/N 1438N62458Bank Of Utah Trustee · Salt Lake City, UTBuilt 1962 · S/N 1404N6331DGilbreath Tony C · Olustee, OKS/N 213
Back to AD 77-07-05 R1