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.

N500XVSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 1200881DN5010PMarkov Michael J · Oceanside, CABuilt 1978 · S/N 2573N50141Greenwood Helicopters Inc · Washington, NCBuilt 1979 · S/N 2603N501JSShelby County Sheriffs Office · Columbiana, ALBuilt 1995 · S/N 5195N501MDAgricultural Air Services LLC · Jupiter, FLBuilt 1991 · S/N 0485EN501RMCity Of Pasadena · Pasadena, CABuilt 2009 · S/N 0598EN501TATomlinson Aviation Inc · Ormond Beach, FLBuilt 1979 · S/N 2592N501VSVertol Systems Co Inc · Destin, FLBuilt 1977 · S/N 170050DN5027PBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 611002DN502CHVertol Systems Co Inc · Destin, FLBuilt 1978 · S/N 180252DN504EHWest Valley Aviation Inc · Five Points, CABuilt 1967 · S/N 19N504LRAviation Company Inc · Cheyenne, WYBuilt 1986 · S/N 126N504SLSouth Carolina Law Enforcement Division · Columbia, SCBuilt 2014 · S/N 0621EN505TVChemair Helicopters Inc · Jefferson, WIBuilt 1980 · S/N 3096N507HWHeliwild Investments LLC · Austin, TXBuilt 1977 · S/N 1270243DN507TVShoreline Aircraft Leasing LLC · Lewes, DES/N 0226EN508PHApex Heli-Support LLC · Phoenix, AZS/N 0182EN508XSSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1976 · S/N 1957N509CGCgck Holdings LLC · Henderson, NVBuilt 1974 · S/N 840634SN50APBank Of Utah Trustee · Salt Lake City, UTBuilt 1979 · S/N 1090585DN50QDNorth Fork Helicopters Ltd · Cutchogue, NYBuilt 1979 · S/N 390478DN50TVJet Ranger LLC · Cuyahoga Falls, OHBuilt 1994 · S/N 4320N50XBRwb 66 LLC · Victoria, TXBuilt 2018 · S/N 0624EN5106YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1981 · S/N 811057DN5108ECorporate Leasing Services LLC · Helena, MTBuilt 1981 · S/N 811075DN510PACedar Helicopters LLC · Shelton, WABuilt 1981 · S/N 811073DN510PDCity Of Oakland · Oakland, CABuilt 1990 · S/N 0400EN5125QTemsco Helicopters Inc · Ketchikan, AKBuilt 1982 · S/N 1100DN5129NEichner Eric D · Ketchikan, AKBuilt 1982 · S/N 1101DN5133UTemsco Helicopters Inc · Ketchikan, AKBuilt 1982 · S/N 1102DN5134VTemsco Helicopters Inc · Ketchikan, AKBuilt 1982 · S/N 1103DN513HAMagnum Aviation LLC · Goff, KSBuilt 1977 · S/N 5013N513PJMid Pacific Aero Services LLC · Honolulu, HIBuilt 1993 · S/N LN048N514PAAa Leasing Lp · Kilauea, HIBuilt 1981 · S/N 510981DN515THRick'S Custom Fencing And Decking Inc · Hillsboro, ORBuilt 2002 · S/N LN099N516BRichey Bradly L · Chico, TXS/N 0378EN516PJSchreindl Lawrence A · Colton, ORS/N 1188DN5185NBrown Helicopter Inc · Pensacola, FLBuilt 1967 · S/N 68-17341N518PAPatriot Aviation Inc · Greenville, DEBuilt 1980 · S/N 400694DN518ZRotormate LLC · Royse City, TXBuilt 1987 · S/N 3991N519PAPatriot Aviation Inc · Greenville, DEBuilt 1977 · S/N 370097DN51MNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1986 · S/N 0200EN5200WEmerald City Aircraft Leasing Inc · Port Orchard, WAS/N 0025EN520ANHeliservices LLC · Wilmington, DEBuilt 1992 · S/N LN-034N520APLn095 1vc Trustee · Wilmington, DEBuilt 2001 · S/N LN095N520EALn062 Inc Trustee · Wilmington, DEBuilt 1994 · S/N LN062N520HCValiair Lc Trustee · Casper, WYBuilt 1992 · S/N LN028N520HSHfn Investments LLC · Birmingham, ALBuilt 1992 · S/N LN012N520KYAltadena LLC · Birmingham, ALBuilt 1992 · S/N LN041N520MDerstine Air Service LLC · Souderton, PABuilt 1978 · S/N 2454
Back to AD 79-21-01 R1