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.

N46CLHelicopters Inc · Wilmington, DEBuilt 1999 · S/N 4518N46EEUnited States Department Of Agriculture · Cedar City, UTBuilt 1990 · S/N 0406EN472MRight Brother Aviation LLC · Chaffee, NYBuilt 1994 · S/N 4327N473EOchoco Wood Products LLC · Prineville, ORBuilt 1991 · S/N 0473EN475ALScotts Helicopter Service Inc · Le Sueur, MNBuilt 1968 · S/N 6675N478NWTmds Air Inc · Gig Harbor, WABuilt 1973 · S/N 530478SN479DBAmerican Honor Foundation Inc · Ocala, FLS/N 5062N47HHJkt LLC · Douglas, WYS/N 2667N480EMidtex Aviation LLC · Midlothian, TXBuilt 1993 · S/N 5001N480FHFalcon Helicopters Inc · Logan, NMS/N 5009N480FTDillon Flight Test Inc · Scottsdale, AZBuilt 1970 · S/N 70-15464N480MTCline Air Services LLC · Ellensburg, WABuilt 1994 · S/N 5003N480RSEuroaviation Inc Trustee · KematenBuilt 1999 · S/N 5038N480TTSanta Lucia Holding · Forked River, NJBuilt 1997 · S/N 5019N481RDSchwam Julie R · Hayden, IDS/N 6716N483RVan Horn Aviation LLC · Tempe, AZBuilt 1969 · S/N 483N48552Brown Helicopter Inc · Pensacola, FLBuilt 2001 · S/N 5275N487ALRedding Air Service Inc · Redding, CABuilt 1997 · S/N 53150N488BCButte County Sheriffs Office · Oroville, CABuilt 1993 · S/N 5103N48HHVarney Aviation LLC · Bangor, MEBuilt 1982 · S/N 3620N48MPPope James D · Lewiston, IDBuilt 1982 · S/N 1137DN493BNStimart Rene D Trustee · Harshaw, WIBuilt 1962 · S/N 1321N49589North Wind Aviation LLC · Chelan, WABuilt 1976 · S/N 1912N499KCopper River Airmotive LLC · Copper Center, AKBuilt 1980 · S/N 20700632N499SLHlh Leasing LLC · Wilmington, DEBuilt 1979 · S/N 190448DN499WMAgricultural Air Services LLC · Jupiter, FLS/N 4376N49BBGiuseppe Baldassarri · Carrollton, GABuilt 1985 · S/N 037N49TJShoreline Aircraft Leasing LLC · Lewes, DEBuilt 1975 · S/N 550747SN49WKRail N LLC · Oracle, AZBuilt 1981 · S/N 611006DN5008KL&R Investment Partners LLC · Wilmington, DES/N 2524N500DCHva Holdings LLC · Gettysburg, PABuilt 1978 · S/N 290456DN500EKKar Aviation LLC · Saltville, VABuilt 1979 · S/N 1190610DN500EVSnohomish County Sheriff · Snohomish, WABuilt 1989 · S/N 0340EN500FCFerguson And Sons Construction LLC · Emmett, IDBuilt 1983 · S/N 0442EN500HJ392e Inc Trustee · Wilmington, DEBuilt 1990 · S/N 0392EN500KYRotor Imaging LLC · Reading, PABuilt 1989 · S/N 0345EN500LKWinco Inc · Aurora, ORBuilt 1983 · S/N 0009EN500MUHva Inc · Summersville, WVBuilt 1996 · S/N 0533EN500MVTreeline Helicopters Inc · Bristol, TNBuilt 1977 · S/N 770156DN500NCSanders Associates LLC · Bluefield, VABuilt 1977 · S/N 1260052DN500NRAycd LLC · Allentown, PABuilt 1983 · S/N 3049N500RTCessna 210 LLC · Waynesville, MOBuilt 1976 · S/N 1050773SN500SLPatriot Marine LLC · New Haven, CTBuilt 1988 · S/N 0309EN500SYNalas Inc Trustee · Wilmington, DEBuilt 1983 · S/N 0007EN500TNOnespan Powerline Services LLC · Peachtree City, GABuilt 1979 · S/N 590521DN500TYSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1984 · S/N 0086EN500TZGulf Helicopters LLC · Santa Fe, TXBuilt 1979 · S/N 590507DN500USYarak Aviation LLC · Big Timber, MTBuilt 1973 · S/N 986N500VSVertol Systems Company Inc · Destin, FLBuilt 1977 · S/N 170072DN500WXTre Aviation Corp · Wilmington, DEBuilt 1992 · S/N 0493E
Back to AD 79-21-01 R1