OpenAirDocs.org
AD 77-24-03

Registered aircraft · 168

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-24-03')
    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-24-03')
  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.

N100LMHaddock Flying Service Inc · Salters, SCS/N 1583N102BBNester Randal K · Seguin, TXBuilt 1959 · S/N 1107N103JAJoann Air Inc · Mulberry, FLS/N 782N1042CRmi Air LLC · Ocilla, GAS/N 846N104HHHaddock Flying Service Inc · Salters, SCBuilt 1960 · S/N 2062N105HHHaddock Flying Service Inc · Salters, SCS/N 1307N106HHHaddock Flying Service Inc · Salters, SCS/N 1375N10728Jstream Lc · Sheridan, WYBuilt 1956 · S/N 798N112BKFordyce Joel M · Gaston, ORBuilt 1957 · S/N 862N1151LClassic Helicopters LLC · Choteau, MTBuilt 1960 · S/N 1233N119NRSlikker Flying Service Inc · Buttonwillow, CABuilt 1966 · S/N 1472N11CUPockrus Pat B · Mineral Wells, TXBuilt 1957 · S/N 983N129HAHiller Aircraft Corp · Firebaugh, CABuilt 1975 · S/N HA3029N12UHJstream Lc · Sheridan, WYBuilt 1962 · S/N 1395N130HAC&C Helicopters Inc · Kuna, IDS/N HA3030N132HASky Copters Inc · Westmoreland, KSBuilt 1975 · S/N HA3032N133HAHanson Leasing Inc · Bad Axe, MIBuilt 1976 · S/N HA3033N133WHFour Creeks Aviation Inc · Visalia, CABuilt 1973 · S/N 1788N1348PCarey James D · Winterset, IAS/N 892N1348XPockrus Pat B · Mineral Wells, TXBuilt 1957 · S/N 901N1348ZPockrus Pat B · Mineral Wells, TXBuilt 1958 · S/N 1043N1349ALyle Daniel · Westmoreland, KSS/N 2035N139HAKnutson Flying Service Inc · Tioga, NDBuilt 1976 · S/N HA3039N144HABank Of Utah Trustee · Salt Lake City, UTBuilt 1976 · S/N HA3044N14637Fort Wolters Helicopter Inc · Mineral Wells, TXBuilt 1993 · S/N 1577N146ETFour Creeks Aviation Inc · Visalia, CABuilt 1976 · S/N HA3046N14MQFort W0lters Helicopter Inc · Mineral Wells, TXBuilt 1961 · S/N 1474N1512EFort Wolters Helicopters · Mineral Wells, TXBuilt 1965 · S/N 1792N1523TBartlett Robert E · Cleveland, TXBuilt 1964 · S/N 1740N156PTWiger Theodore L · Falcon Heights, MNBuilt 1956 · S/N 851N16NRParagon Helicopter Services LLC · Claremore, OKBuilt 1964 · S/N 1755N173SJAnthony Ghidossi Chemical LLC · Marysville, WABuilt 1981 · S/N 5170N175HAShearer John · The Dalles, ORBuilt 1978 · S/N HA3075N17MQPan Bar Aviation Inc · Pittsburgh, PAS/N 787N180HAAmbrosini Helicopters Inc · Fresno, CABuilt 1980 · S/N HA3080N196FTContinental Title Trust LLC Trustee · Wichita, KSBuilt 1962 · S/N 1364N2068VFort Wolters Helicopter Inc · Mineral Wells, TXS/N 5107N222TEFranke Darren · Yorktown, TXBuilt 1955 · S/N 802N2275MBorszich Claude C Jr · Phoenix, AZBuilt 1961 · S/N 1305N22SPParagon Helicopter Services LLC · Claremore, OKBuilt 1959 · S/N 1214N233WHBank 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 800N25196Fort Wolters Helicopter Inc · Mineral Wells, TXBuilt 1976 · S/N 101N2678YNorthwest 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 1332
Back to AD 77-24-03