OpenAirDocs.org
AD 77-20-02

Registered aircraft · 139

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-20-02')
    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-20-02')
  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.

N106DABeartooth Fencing LLC · Reed Point, MTBuilt 1976 · S/N 1050N111EEPereira Alfred R Jr · Valley Springs, CABuilt 1977 · S/N 1075N116TBMcmullan Francis G · Weirsdale, FLS/N 362N122TVButler Aaron · Rupert, IDBuilt 1976 · S/N 1049N128SAFly-Right Aviation LLC · Anderson, SCS/N 355N132ABScenix Air LLC · Batavia, OHBuilt 1974 · S/N 1004N13CMBolin William E · Smithville, OHBuilt 1972 · S/N 090N142LKummoung Jeffery S · Middleburg, FLBuilt 1976 · S/N 1036N1577ESeibert Lynn K · Fresno, CAS/N 1131N170QCherry Calvin L · Paso Robles, CABuilt 1978 · S/N 1137N173Shafer Robert T · Grosse Ile, MIBuilt 1974 · S/N 218N17YBAhearn Nicholas · Harper, TXBuilt 1978 · S/N 1158N191JStyer David B · Pendleton, ORBuilt 1977 · S/N 390N193EHillberg David · Fountain Valley, CAS/N 008N194EBechtel Friend · Dry Ridge, KYS/N 009N200EHD & M Aviation Inc · Amelia, OHBuilt 1974 · S/N 200N212AKHinshaw Martin E · Wasilla, AKBuilt 1978 · S/N 431N221MPBenson Aviation LLC · Mehoopany, PAS/N 1147N24RBBreeden Wayne M · Memphis, TNBuilt 1971 · S/N 057N255JSFalcon Helicopters Inc · Logan, NMS/N 364N277RDWestline Corp · Medina, OHBuilt 1978 · S/N 1156N280AL2e2 Corporation · Menlo Park, CABuilt 1980 · S/N 1210N280FUAdf Helicopters Inc · Brewster, WAS/N 1007N280MGM&M Charter LLC · Mountville, PABuilt 1978 · S/N 1135N280QCasey Aviation Inc · Burke, TXBuilt 1975 · S/N 1011N280WRBeacon Aviation Flight Services LLC · Rogers, ARBuilt 1977 · S/N 1108N285QAdams Aircraft LLC · Wilmington, DES/N 297N286QPagni Peter P · Anchorage, AKBuilt 1975 · S/N 300N296QSteffens Robert S · Peapack, NJBuilt 1975 · S/N 316N297QBlue Sky Helicopter Service LLC · Owendale, MIS/N 317N31216Valley Aire Inc · Marlboro, NYBuilt 1975 · S/N 290N3143CAuron Chris · Naples, FLBuilt 1977 · S/N 1103N319ENMedic Choppers LLC · Springdale, ARBuilt 1975 · S/N 319N3235BHbhis LLC · Gnadenhutten, OHS/N 1010N3398MMott William R · Beach Lake, PABuilt 1976 · S/N 1037N35ZEFerree Thomas L · Wampum, PABuilt 1981 · S/N 508-2RN403TAJ & J Shop Heliair LLC · Laurel, DES/N 1204N40DLStyer David B · Pendleton, ORBuilt 1971 · S/N 071N4210Lrh Equipment LLC · Pendleton, ORS/N 421N43MHKorb Thomas M · Owasso, OKBuilt 1978 · S/N 1148N46MUMedic Choppers LLC · Springdale, ARS/N 253N4874Goin Jeff Trustee · Polk City, FLBuilt 1968 · S/N 025N4878Medic Choppers LLC · Springdale, ARBuilt 1969 · S/N 029N4889Albert Lea Arpt Inc · Albert Lea, MNBuilt 1969 · S/N 041N494HSale Reported · West Palm Beach, FLSale reported, pending cancellationBuilt 1975 · S/N 309N501EHDupont Pierre B · Menominee, MIBuilt 1966 · S/N 5N50DRAdf Helicopters Inc · Brewster, WAS/N 1203N51659Hawk Robert S · Argyle, TXBuilt 1977 · S/N 1098N51665Rotor-Lift LLC · Swartz Creek, MIS/N 404N51693Borreson Anthony · Reno, NVBuilt 1977 · S/N 411
Back to AD 77-20-02