OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,394

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.

N7674HOverly Terrence L · Tok, AKS/N 12-554N7674PChurches Michael D · Smyrna, TNS/N 24-2887N7674SMurtagh Johhny T · Lexington, MSBuilt 1976 · S/N 932-76N7675RKline John C · Wolcottville, INBuilt 1970 · S/N M-1297N7675WAltitude Aircraft Leasing LLC · Burnet, TXBuilt 1964 · S/N 28-1642N7676FNationwide Aviation LLC · Hudson Oaks, TXBuilt 1976 · S/N 28-7715234N7676GPalmer Michael C · Emmett, IDBuilt 1970 · S/N 17259376N7676WEsparza Vincent A · Friona, TXS/N 28-1662N7676YCoffman Robert P · Bigfork, MTBuilt 1964 · S/N 30-755N7677FWestern Robert E · Stanley, NDS/N 28-7715235N7677PHenderson William C · Grafton, WVBuilt 1961 · S/N 24-2888N7677RAlpha Bravo Charlie 1 Corp · Houston, TXS/N M-1288N7677WNikolic Peter Jr · Momence, ILBuilt 1964 · S/N 28-1663N7678DEldridge William D · Anchorage, AKBuilt 1957 · S/N 18-5900N7678GTanner Michael J · Hooksett, NHS/N 17259378N7678PMunday Jeff R · Waverly, GAS/N 24-2889N7678WDsr-Cherokee 180 LLC · Dallas, TXBuilt 1964 · S/N 28-1665N7679FScott Field Flying Club LLC · Elgin, IABuilt 1976 · S/N 28-7790215N7679GShipp-Hove Kylan · Mesa, AZBuilt 1970 · S/N 17259379N7679HSummerskyz Inc · Urbana, ILBuilt 2004 · S/N 3540N767ACWooldridge Kent L · Albany, ORBuilt 2000 · S/N 410-2000N767CDTyler Flyers Inc · Tyler, TXBuilt 1979 · S/N 17273607N767DCMariah Aviation Corp · Miami, FLBuilt 2000 · S/N 60034N767ERJet Stream Jockey LLC · Venice, CABuilt 2005 · S/N 3956N767FTRenner Brian E · North Port, FLBuilt 1978 · S/N AA5A0646N767GCKiernan Eric J · Bozeman, MTBuilt 2002 · S/N 23683N767GPGoodwinds Aero LLC · Roseburg, ORBuilt 2000 · S/N 25578N767JJLiberty Aero Executives LLC · Carmel, INBuilt 1999 · S/N 13N767JWRoads End Aero LLC · Erwinna, PABuilt 1971 · S/N 7777N767NTognoli Steve F · Union, ORBuilt 1955 · S/N 18-4484N767PAviation Investments Inc · Virginia Beach, VAS/N 262-73N767PAPurdue Aviation LLC · West Lafayette, INBuilt 2002 · S/N 4496114N767RCTalarik Air LLC · Memphis, TNBuilt 2003 · S/N 21975N767SECoyote Aviation LLC · Carefree, AZBuilt 2004 · S/N 1374-2004N7680DHart Gary L · Fernwood, IDS/N 18-5902N7680FMag Avionics LLC · Woodlands, TXBuilt 1976 · S/N 28-7790217N7680GGulyash Michael J · Ukiah, CAS/N 17259380N7680RPotter Steven R · Grapevine, TXS/N MB-502N7680WMearbell Kevin J · Niagara Falls, NYBuilt 1964 · S/N 28-1667N7681GCompass Aviation Inc · Shelby, NCBuilt 1970 · S/N 17259381N7681SCawley Jeffrey W · Buckley, WABuilt 1976 · S/N 907-76N7682DMckay Don · Soldotna, AKS/N 18-5904N7682RTrull Stephen G · Golden Valley, MNBuilt 1969 · S/N MB-452N7682WMcintosh Doyle · North Ogden, UTBuilt 1964 · S/N 28-1670N7683DYellow Bird Inc · Doral, FLBuilt 1957 · S/N 18-5905N7683FFisch David S · Leland, NCBuilt 1976 · S/N 28-7725103N7683GBalgoyen James T · Charlotte, MIBuilt 1970 · S/N 17259383N7683HNovember Alpha LLC · Dover, DEBuilt 2005 · S/N 3885N7684DRegistration Pending · Destin, FLRegistration pendingBuilt 1957 · S/N 18-5906N7684FLettunich Mitchell C · Newcastle, CAS/N 28-7715238
Back to AD 79-10-03 R2