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.

N5522COswald Ron · Eden Prairie, MNBuilt 1986 · S/N 21064973N5522EBauman Raymond Scott · Douglas, WYBuilt 1958 · S/N 17022N5522GCoffroth James R · Jamestown, TNBuilt 1969 · S/N 15071022N5522SAmeriflyers Of Texas Inc · Addison, TXBuilt 2014 · S/N 172S11430N5522XChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11429N55231Golf November Aero LLC · Sunnyvale, CABuilt 2014 · S/N 172S11414N55234Alien Invaders LLC · Medina, WABuilt 2014 · S/N 172S11415N55236Bobnal LLC · Conway, SCBuilt 1981 · S/N 17275139N5523GSamadzai Ahmad W · Mount Vernon, ILBuilt 1969 · S/N 15071023N5523QDolphin Leasing LLC · Daytona Beach, FLBuilt 2014 · S/N 172S11412N5523RPlett John · Anaconda, MTBuilt 1979 · S/N 172RG0069N5523SDj Flight Service LLC · Little Falls, MNBuilt 1966 · S/N 188-0023N5523VDolphin Leasing LLC · Daytona Beach, FLBuilt 2014 · S/N 172S11413N5523YSimmons Scott · Anchorage, AKBuilt 1981 · S/N 21064236N55242Hills Holding · Newark, DEBuilt 1981 · S/N 17275142N55246Kadena Aero Club · Apo, APBuilt 1981 · S/N 17275143N55250Colorado Aircraft Corp · Watkins, COBuilt 1981 · S/N 17275144N55256Notam Aviation LLC · Portage Des Sioux, MOBuilt 1981 · S/N 17275146N5525TDavis Ronnie L · Okmulgee, OKBuilt 1964 · S/N 17251425N5525USheriffs Department · Oakland, CABuilt 1979 · S/N U20605311N55264Ace Aircraft Leasing Inc · Nazareth, PABuilt 1981 · S/N 17275147N5526BDoelger Parker · Norwood, NYBuilt 1956 · S/N 33526N5526JBravo Leasing LLC · Daytona Beach, FLBuilt 2014 · S/N 172S11484N5526RQualitair LLC Trustee · MichelstadtS/N 172RG0070N5527BAdrenaline Inc · Chambersburg, PAS/N 33527N5527CMetzka Andrew J · Chillicothe, ILBuilt 1950 · S/N 19574N5527GFly Around Alaska LLC · Palmer, AKBuilt 1969 · S/N 15071027N5527RSchultz David M · East Gull Lake, MNBuilt 1965 · S/N 17253106N55285Aerosim Academy Inc · Sanford, FLBuilt 2014 · S/N 172S11511N5528AWarden Hutterian Brethren · Warden, WAS/N 21063482N5528CBaum Jeffrey C · Sheridan, WYBuilt 1950 · S/N 19575N5528EZook Kevin J · East Waterford, PABuilt 1958 · S/N 17028N5528GRick Aviation Inc · Newport News, VABuilt 1969 · S/N 15071028N5528RVroom Brian D · Tucson, AZS/N 172RG0071N55291Riverside Flight Academy LLC · Riverside, CABuilt 1981 · S/N 17275152N55292Aerosim Academy Inc · Sanford, FLBuilt 2014 · S/N 172S11515N55294Heavy Metal Air LLC · Farmingdale, NYBuilt 2014 · S/N 172S11516N55296Heavy Metal Air LLC · Farmingdale, NYBuilt 2014 · S/N 172S11517N55297Goodhue LLC · Myrtle Beach, SCBuilt 2014 · S/N 172S11518N55299Trego/Dugan Aviation Of Grand Island Inc · Grand Island, NEBuilt 1981 · S/N 17275154N5529CHaralson Stephen K Trustee · Claremore, OKBuilt 1950 · S/N 19576N5529EKaono Jerry C · Carson, CABuilt 1958 · S/N 17029N5529GSmoot Jeremy D · Fort Wayne, INS/N 15071029N5529NTime 2 Fly LLC · Conroe, TXBuilt 1980 · S/N 18267771N5529RCarlson Scott M · Sycamore, ILBuilt 1965 · S/N 17253109N5529TCornell James R · Winston Salem, NCBuilt 1964 · S/N 17251429N5529ZAerosim Academy Inc · Sanford, FLS/N 172S11514N552KKing Monte L · Kerrville, TXBuilt 1973 · S/N 177RG0367N552MNMtc Air LLC · Blue Ridge, GABuilt 2005 · S/N 18281588N552NDOdegaard Wings Inc · Kindred, NDS/N 172S10859
Back to AD 79-10-14 R1