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.

N520NQuantumtrace Inc · Incline Village, NVBuilt 1992 · S/N LN031N520NTAurora Meridian LLC · Portland, ORS/N LN066N520PAMid Pacific Aero Services LLC · Honolulu, HIS/N 490505DN520WHWinco Inc · Aurora, ORBuilt 1988 · S/N 0607FFN521PDSale Reported · Costa Mesa, CASale reportedBuilt 1988 · S/N 0321EN521TCTre Aviation Corp · Wilmington, DEBuilt 1969 · S/N 1090201EN522MAProvine Helicopter Service Inc · Greenwood, MSBuilt 1980 · S/N 2986N5238CAviation Advantage Inc · Tabor City, NCS/N 0151EN525ZDg&R LLC · Murray, UTBuilt 1977 · S/N S-349N5264QSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1986 · S/N 0126EN526HAHelo N526ha LLC · Richmond, VABuilt 2000 · S/N 4541N5277FCity Of Houston · Houston, TXBuilt 2008 · S/N 0587EN5278FCity Of Houston · Houston, TXBuilt 2008 · S/N 0588EN5279FCity Of Houston · Houston, TXBuilt 2009 · S/N 0596EN5280FCity Of Houston · Houston, TXS/N 0597EN5284FCity Of Houston · Houston, TXBuilt 2008 · S/N 0585EN528HPCollective Ag LLC · Osceola, NEBuilt 1971 · S/N 631N52BHNipper Troy R · Texarkana, TXS/N 1652N52FAZma LLC · North Little Rock, ARBuilt 1981 · S/N 3424N52RDHelicopter Services West LLC · Benicia, CABuilt 1970 · S/N 110274SN52ZSouthern Helicopter Service Inc · Millington, TNS/N 2251N52ZXRichard Schuman LLC · Kailua, HIS/N 5515N530DGHlh Leasing LLC · Wilmington, DES/N 0603FFN530FCFerguson And Sons Construction · Emmett, IDBuilt 2007 · S/N 0712FFN530RRVertical Access Helicopters LLC · Clermont, FLS/N 1302N533DRLt Aviation LLC · Lexington, KYBuilt 1979 · S/N 490533DN533RAEnglish Air Service LLC · Georgetown, TXBuilt 1970 · S/N 533N535HASummit Helicopters Inc · Salem, VABuilt 1977 · S/N 5035N537STJ&J Holdings And Investments LLC · Phoenix, AZBuilt 1998 · S/N 0540EN537TMbm Aviation Consultants Inc · Wilmington, DEBuilt 1980 · S/N 2993N53846Aerial Solutions Inc · Tabor City, NCBuilt 1982 · S/N 1070-DN538STJ&J Holdings And Investments LLC · Phoenix, AZS/N 0192EN53BGRegistered aircraftBuilt 1980 · S/N 6034N53BNSmith Air LLC · Shedd, ORBuilt 1970 · S/N 69-15999N53JWLegacy Endeavors LLC · Bigfork, MTBuilt 1970 · S/N 581N53MAAg Air Inc · Johnstown, COBuilt 1977 · S/N 2285N543CCBighorn Flying Co LLC · Wood River, NEBuilt 1982 · S/N 3593N543HAMagnum Aviation LLC · Goff, KSBuilt 1978 · S/N 5043N549VSVertol Systems Co Inc · Destin, FLBuilt 1981 · S/N S-549N550JMNational Aggregates Inc · Malvern, OHBuilt 1982 · S/N 0013EN553EAEdgefield Aviation LLC · Sandy, ORBuilt 1966 · S/N 215N555NBHelicopter Services Of Illinois LLC · Fisher, ILBuilt 1977 · S/N 2306N555PPEl Aero Services LLC · Elko, NVBuilt 1988 · S/N 4021N555SJApex59 LLC · Saint Paul, MNBuilt 1968 · S/N 308N555THRegistered aircraftBuilt 1973 · S/N 1173N556CPCity Of Columbus · Columbus, OHBuilt 2009 · S/N 713FFN556MHAa Leasing Lp · Kilauea, HIBuilt 1977 · S/N 570143DN557TSLone Oak Aviation LLC · Stayton, ORBuilt 1976 · S/N 1160037DN55ASBlue Air Training Corp · Las Vegas, NVBuilt 2008 · S/N 029N55BLNorth Wind Aviation LLC · Cottage Grove, ORBuilt 1987 · S/N 3989
Back to AD 79-21-01 R1