OpenAirDocs.org
AD 79-21-01 R1

Registered aircraft · 1,074

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:79-21-01-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:79-21-01-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.

N369SDPyramid Property Development And Management LLC · Cedar Lake, INBuilt 2000 · S/N 0548EN369TAHva Inc · Summersville, WVBuilt 1996 · S/N 0529EN369TRChehalem Helicopters LLC · Newberg, ORBuilt 1977 · S/N 570141DN369WYReece Construction Company · Marysville, WABuilt 1981 · S/N 510976DN369ZMHelios Helicopters LLC · Clackamas, ORS/N 1000259SN36KRDragonfly Aviation LLC · Mirando City, TXBuilt 1978 · S/N 580315DN36MQRotor LLC · Dover, DEBuilt 1993 · S/N 4262N371AHSlykerman John A · Bakersfield, CABuilt 1976 · S/N 1660N372NSEwing Flying Service LLC · New Roads, LABuilt 1970 · S/N 70-15372N37WABoston Executive Helicopters LLC · Norwood, MABuilt 1981 · S/N 3433N382CAChem-Air LLC · Shreveport, LABuilt 1977 · S/N 2091N382SPTag Aviation LLC · Casper, WYBuilt 1977 · S/N 2271N383FJ&J Holdings And Investments LLC · Phoenix, AZBuilt 1990 · S/N 0440EN386PZFast Boy Equipment LLC · Houston, TXS/N 407N3897UCounty Of Cape May · Cape May Ch, NJBuilt 1980 · S/N 3205N38HHChemair Helicopters Inc · Jefferson, WIBuilt 1976 · S/N 2016N38VABrown Helicopter Inc · Pensacola, FLBuilt 1993 · S/N 2040N39049Aspen Helicopters Inc · Oxnard, CABuilt 1980 · S/N 3101N390LHDsl Aviation LLC · Perham, MNBuilt 1977 · S/N 2234N39101Scotts Helicopter Service Inc · Le Sueur, MNBuilt 1981 · S/N 3289N3917GBank Of Utah Trustee · Salt Lake City, UTBuilt 1974 · S/N 1364N393SSouthwest Heliservices LLC · Mesa, AZBuilt 1980 · S/N 45494N398WCBucks Air Charters Inc · Wilmington, DEBuilt 1976 · S/N 1966N39MKXtreme Aviation LLC · Falkville, ALBuilt 1980 · S/N 2984N3DUCrile Consolidated Industries Inc · Washington, PABuilt 1998 · S/N 4492N3TVMission Air Capital Services L L C · San Antonio, TXS/N 2678N3YJHelicopters Inc · Linden, NJBuilt 1994 · S/N 4322N400HEWallace Robert W · Plymouth, MABuilt 1985 · S/N H-22N400MBPrecision Heli-Support LLC · Mesa, AZBuilt 1990 · S/N 0420EN4010GScotts Helicopter Services Inc · Le Sueur, MNBuilt 1968 · S/N 183N40125N525gm LLC · Bozeman, MTBuilt 2020 · S/N 0625EN40290Haddock Flying Service Inc · Salters, SCBuilt 1980 · S/N HA3081N402BWLiesch Robert H · Port Orange, FLBuilt 2007 · S/N 29008CN4032YBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 5180N4037LSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 0589EN403AHMclaughlin Charles W Trustee · Oxnard, CABuilt 1986 · S/N 8009N4042GKlein Flying Service Inc · Lawrenceville, ILS/N 242N405ATRotor Blade LLC · Georgetown, SCBuilt 1980 · S/N 500717DN4068GGulf Coast Helicopters Inc · Pearland, TXBuilt 1968 · S/N 229N406DBRight Brother Aviation LLC · Chaffee, NYBuilt 2002 · S/N 4561N407ADOcean Air Helicopters Inc · Port Orford, ORBuilt 1988 · S/N 4023N407CCCounty Of Contra Costa · Martinez, CABuilt 1997 · S/N 53090N407CHClassic Medical Inc · North Salt Lake, UTBuilt 1996 · S/N 53011N407FCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 1996 · S/N 53050N407GHRotorcraft Support Inc · Fillmore, CABuilt 1996 · S/N 53075N407KBOrange County Sheriffs Office · Orlando, FLBuilt 1997 · S/N 53146N407PRWindsock Managmement LLC · Little Rock, ARBuilt 1997 · S/N 53162N407RVHelicopter Services Of Illinois LLC · Fisher, ILBuilt 1982 · S/N 3621N407UTMed Trans Corp · Denton, TXBuilt 1996 · S/N 53036N4088YDumont Associates · Morris Plains, NJBuilt 1990 · S/N 4088
Back to AD 79-21-01 R1