OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,396

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-10-03-R2')
    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-10-03-R2')
  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.

N5960WNewman Matthew T · Cedar Park, TXBuilt 1966 · S/N 28-3807N5960ZMielke James W · Wasilla, AKS/N 18-8179N5962USieber Eric P · Shelburne, VTBuilt 1970 · S/N 28-26864N5962WMcmath Stephen S · Spokane Valley, WABuilt 1966 · S/N 28-3821N5963QKatz Matthew · Los Angeles, CABuilt 1965 · S/N 3199N5963WPalm-Air Aviators LLC · Springville, UTBuilt 1968 · S/N 28-24780N5963ZMcmahan Charles B · Gakona, AKBuilt 1965 · S/N 18-8260N5964FDillard Gregory S · Columbus, MSBuilt 1976 · S/N 28-7715162N5964QLin Andrew Hsia · Huntingtown, MDBuilt 1965 · S/N 3200N5964UChandler Joseph R · Midlothian, TXS/N 28-26818N5965LRegistered aircraftBuilt 1972 · S/N AA5-0255N5965WHadfield Brant C · Kirkwood, MOFirst renewal noticeBuilt 1966 · S/N 28-3812N5966FHalter George R 3rd · West Chester, PABuilt 1976 · S/N 28-7790146N5967WZillah Heights Cherry Growers LLC · Zillah, WABuilt 1966 · S/N 28-3831N5968DGrand Lake Air Ventures LLC · Celina, OHBuilt 1956 · S/N 22-4633N5968QChess House LLC · Canton, SDS/N 3202N5968WDalken Dustin A · Fairhope, ALBuilt 1967 · S/N 28-3860N5969DLynn John E · Fairborn, OHBuilt 1956 · S/N 22-4634N596PHOtt Juston E · Newton, ALBuilt 1968 · S/N 28-24782N596SGerondale Gerald G · League City, TXS/N 23042N5970BBlake Terry L · Saint Clair, MIS/N 345N5970QYeager Robert Allen · Oregon City, ORBuilt 1965 · S/N 3203N5970UThatcher Jay C · Helena, OHBuilt 1970 · S/N 28-26857N5970WBlessing Randall L · Lebanon, PABuilt 1967 · S/N 28-4020N5971DHenderson Donald G · Bedford, INS/N 18-5430N5971URegistered aircraftBuilt 1970 · S/N 28-26851N5971WGoede Mark D · Wildwood, MOS/N 28-4021N5971ZFlight World Inc · San Juan, PRBuilt 1958 · S/N 18-6288N5972DAufderheide Flying Service Inc · Dewitt, ARBuilt 1956 · S/N 18-5432N5972FFulhage Eric D · Yates Center, KSBuilt 1976 · S/N 28-7790148N5972UToporkova Kamila E · Whitewater, CABuilt 1970 · S/N 28-26858N5973PSp Quality Leasing Inc · Wshngtn Ct Hs, OHBuilt 1959 · S/N 24-1066N5973WValant Group Inc · Valrico, FLBuilt 1967 · S/N 28-3919N5974PWilliams Robert A · Akron, OHBuilt 1959 · S/N 24-1067N5974QTaylor Timothy T · Quitman, ARFirst renewal noticeBuilt 1965 · S/N 3205N5974UW8s Enterprises LLC · Stillwater, OKBuilt 1970 · S/N 28-26861N5976EFunkhouser Dennis E · Fredericksburg, VABuilt 1978 · S/N 17271978N5976XFandler Frederick · Shady Shores, TXBuilt 1961 · S/N 119N5977DCarr James C · Wasilla, AKBuilt 1957 · S/N 18-5439N5977UMorrow Robert H · Wyndmoor, PABuilt 1970 · S/N 28-26862N5977ZBrown Michael S · Kenai, AKBuilt 1965 · S/N 18-8234N5978DWinkelman Ronald A · Chugiak, AKBuilt 1956 · S/N 18-5441N5978QBauer Jared R · Sugar City, COBuilt 1965 · S/N 3208N5979DVeal Tim S · Egegik, AKBuilt 1956 · S/N 18-5442N5979UWings Of Grace Ministries Inc · Melbourne, FLS/N 28-26867N5979ZSchuster Timothy A · Carrington, NDBuilt 1965 · S/N 18-8237N597DMBrandon Air LLC · Valley Stream, NYBuilt 1976 · S/N 17268041N597JFDiamond Travel LLC · Olive Branch, MSBuilt 1977 · S/N 28-7890262N597LELeading Edge Aviation Inc · Bend, ORFirst renewal noticeBuilt 1986 · S/N 597N597SMoore Charles W · Lees Summit, MOBuilt 1999 · S/N 23995
Back to AD 79-10-03 R2