AD 79-10-14 R1

Registered aircraft · 56,582

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-14-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-10-14-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.

N94588Burt Lisa C · Justin, TXS/N 18266449N9458TWasp Air LLC · Hamilton, MTBuilt 1960 · S/N 57258N9458XAnderson William B · Rogers, ARBuilt 1961 · S/N 21057758N94592Oklahoma State University · Stillwater, OKBuilt 1978 · S/N 18266452N94596Koulbou Moussa A · Chandler, AZBuilt 1978 · S/N 18266455N94598Klein Thomas Alan · North Pole, AKBuilt 1978 · S/N 18266457N94599Ams Aviation LLC · South Bend, INBuilt 1978 · S/N 18266458N9459BMiller Jason · Clifton, NJS/N 55259N9459CFlight Trainer LLC · Wilmington, DEBuilt 2012 · S/N 172S11207N9459MCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1978 · S/N U20604547N945ASA2g International LLC · San Juan Capo, CABuilt 1978 · S/N 33701844N945CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282407N945EBFlying Z LLC · East Lansing, MIBuilt 1998 · S/N 18280137N945FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13461N945GPrimewings Holdings LLC · Sunnyvale, CABuilt 2019 · S/N 18283067N945MCPacific Northwest Aircraft Leasing Inc · Meridian, IDBuilt 2009 · S/N 172S10945N945PDHickmott Mark T · Sunol, CABuilt 2001 · S/N 18280945N945SAJahawk Leasing LLC · Sugar Grove, ILS/N 172S9454N945SMFive Rivers Flight Training LLC · Livermore, CABuilt 1981 · S/N 17274742N945TC R Transport Inc · Wilmington, DES/N 17265082N945XPeraton Services LLC · Bozeman, MTBuilt 2016 · S/N 172S11692N94608Hansen David A · Milton Freewater, ORBuilt 1978 · S/N 18266459N9460BEdwards Ag Service · Primghar, IABuilt 1958 · S/N 55260N9460UMarkham Clint D · Vinita, OKBuilt 1976 · S/N 15078408N94618Flight Trainer LLC · Wilmington, DEBuilt 2012 · S/N 172S11209N94619Fanning Fred W · Fairlawn, OHBuilt 1978 · S/N 18266463N9461DDurghinescu Cris Nicolae · Rancho Mirage, CABuilt 1984 · S/N 172RG1174N9461GMillionair Inc · Ferndale, WAS/N U20601661N9461MMaster Chief Cricket LLC · Morgan City, LABuilt 1970 · S/N 21059361N9461REthnos360 Inc DBA · Mcneal, AZBuilt 1985 · S/N U20606868N9461ZMichigan Aeronautics Commission · Lansing, MIBuilt 1981 · S/N U20606505N94623Watts Mark A · Medicine Lodge, KSBuilt 1978 · S/N 18266464N9462BPustell Robert J · West Ossipee, NHBuilt 1958 · S/N 55262N9462CAcp Aviation LLC · Oakdale, LABuilt 1955 · S/N 31860N94631Flight Trainer LLC · Wilmington, DEBuilt 2012 · S/N 172S11213N9463BSanford Scott · Rancho Cucamonga, CABuilt 1958 · S/N 55263N9463COgden Dale · Buckley, WABuilt 1955 · S/N 31861N9463DHarris Aircraft Leasing Co · Oklahoma City, OKBuilt 1984 · S/N 172RG1175N9463LFlight Trainer LLC · Wilmington, DEBuilt 2012 · S/N 172S11212N9463TMcbee Kenneth H · Pasadena, TXBuilt 1960 · S/N 57263N9463UMonday Terry A · Greenville, NCBuilt 1976 · S/N 15078411N94643Ashmore Mark D · Naples, IDBuilt 1978 · S/N 18266471N94645Bozic Zeljko · San Pedro, CABuilt 1978 · S/N 18266472N9464CSpencer Page Trustee · Anchorage, AKBuilt 1955 · S/N 31862N9464HAlsworth Leon R · Port Alsworth, AKS/N 18503440N9464M2morrow Aviation LLC · Abilene, TXBuilt 1977 · S/N 21062079N9464THansen Peter J · Collierville, TNBuilt 1960 · S/N 57264N94651Patrick A Testerman · Maple Grove, MNBuilt 1978 · S/N 18266475N9465AMorris Mark A · Westlake, TXBuilt 1949 · S/N 15286N9465BBartlett Robert E · Cleveland, TXBuilt 1958 · S/N 55265
Back to AD 79-10-14 R1