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.

N6152TSpate Aviation LLC · Albuquerque, NMBuilt 1983 · S/N 6152N6181AHiline Inc · Ball Ground, GABuilt 1993 · S/N 4277N6181KBd Aviation LLC · Sundance, WYBuilt 1993 · S/N 4276N6183BHegge Malik Trustee · Mills, WYBuilt 1984 · S/N 6183N618PCMandes George J · Homer, AKBuilt 1992 · S/N 4222N61FMIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 1981 · S/N 7197N61PHTre Aviation Corp · Wilmington, DEBuilt 1981 · S/N 3282N62409Costa James J · Goff, KSBuilt 1962 · S/N 1455N6246WStarfire Aviation LLC · Renton, WABuilt 1968 · S/N 880712N624KRotary Flight LLC · Wilmington, DEBuilt 1974 · S/N 1540N6295PCaribe Helicopters Inc · Coral Gables, FLBuilt 1972 · S/N 520378SN62EHJuliett Tango LLC · Alpine, WYBuilt 1991 · S/N 4191N62FHelicopters Inc · Linden, NJBuilt 1995 · S/N 4341N62UCCbft LLC · Mobile, ALBuilt 1979 · S/N 1090594DN633JHJack Harter Helicopters Inc · Lihue, HIBuilt 1987 · S/N 0230EN63446Helicopter Services Of Illinois LLC · Fisher, ILBuilt 1981 · S/N 3439N63864Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1999 · S/N 4517N63888Flick Todd · Skull Valley, AZBuilt 1989 · S/N 3990N63SHMaine Helicopters Inc · Whitefield, MEBuilt 1979 · S/N 2640N642ABCatalyst Aviation LLC · Hammonton, NJBuilt 1991 · S/N 5498N648CAChem-Air LLC · Shreveport, LABuilt 1982 · S/N 3626N64JBNc Transportation Inc · Loudon, NHBuilt 1978 · S/N 2437N64RSRainbow Air Inc · Niagara Falls, NYBuilt 1989 · S/N 0320EN64TMLake State Companies LLC · Anchor Point, AKS/N 2513N65150Burns Craft LLC · Wilmington, DEBuilt 1971 · S/N 71-20466N651RPPeasant Air LLC · Parkersburg, WVBuilt 2008 · S/N 0583EN65231Louisville Metro Government · Louisville, KYBuilt 2001 · S/N 5281N652BBAgricultural Air Services LLC · Jupiter, FLBuilt 1984 · S/N 3800N655HAHelicopter Applicators Inc · Gettysburg, PABuilt 1970 · S/N 70-15555N656EAEdgefield Aviation LLC · Sandy, ORBuilt 1973 · S/N 73-21911N656HAHelicopter Applicators Inc · Gettysburg, PABuilt 1969 · S/N 69-16127N656TLTopside Aviation Inc · Brasstown, NCBuilt 1971 · S/N 656N657CCClear Creek Construction LLC · Lysite, WYBuilt 1977 · S/N 2295N65CRWinco Inc · Aurora, ORBuilt 1976 · S/N 1160011DN65DACenter For Vertical Studies LLC · Sheridan, WYBuilt 1991 · S/N S-854N66013Blackbird Aero LLC · Boca Raton, FLBuilt 2002 · S/N 5283N66RLSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N S-801N66SDEnforcement Aviation Services Inc · Midway City, CABuilt 1985 · S/N 0147EN67053West Hills Aviation Inc · Huron, CABuilt 1993 · S/N 5105N67113West Hills Aviation Inc · Huron, CABuilt 1993 · S/N 5111N67147Usda Aphis Wildlife Services · Cedar City, UTBuilt 1993 · S/N 5115N67172Veturis David · Lake Forest, CABuilt 1993 · S/N 5118N67234Brown Helicopter Inc · Pensacola, FLBuilt 1993 · S/N 5125N67265Usda Aphis Ws · Cedar City, UTBuilt 1993 · S/N 5130N67273Brown Helicopter Inc · Pensacola, FLBuilt 1994 · S/N 5133N67323Coastal Helicopters Inc · Panama City, FLBuilt 1993 · S/N 5136N67363Georgia State Patrol Aviation Division · Kennesaw, GAS/N 5145N67374Blair Air Service Inc · Lemoore, CABuilt 1994 · S/N 5146N67411Coastal Helicopters Inc · Panama City, FLS/N 5148N67428United States Army · Redstone Arsenal, ALBuilt 1994 · S/N 5149
Back to AD 79-21-01 R1