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.

N5383DTong Sheng Aviation LLC · Irvine, CABuilt 1979 · S/N 17272557N5383KAmerican Patrols Inc · Midland, TXBuilt 1980 · S/N 17274088N5383NCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1980 · S/N 18267678N5383QEight Three Quebec LLC · Arlington, VABuilt 1972 · S/N 15073283N5383SScharber Patrick · Monticello, MNBuilt 1966 · S/N 337-0483N5383TMeyers Morgan J · Twin Falls, IDS/N 17251283N5383XWillard Raymond C · Wasilla, AKBuilt 1969 · S/N 18051898N5384Penhorwood Joshua M · Shubuta, MSBuilt 1967 · S/N R172-0238N5384BGust Dale A · Boise, IDBuilt 1956 · S/N 33384N5384CPrice Edsel B · Leesville, SCBuilt 1950 · S/N 15517N5384KVascular Wings LLC · Friendswood, TXBuilt 1980 · S/N 17274089N5384NBlizzard Johnny F · Lake City, FLS/N 18267679N5384RKidd Frank E Jr · Wilson, NCBuilt 1965 · S/N 17252919N5384TJohnson William R · Virginia Beach, VABuilt 1964 · S/N 17251284N5385DDg Aviation Services Inc · Merritt Island, FLBuilt 1979 · S/N 17272558N5385HBeer Steve Z · Morristown, NJBuilt 1981 · S/N 18267868N5385JAerowood Aviation LLC · Monroe, NCBuilt 1980 · S/N 17273775N5385NTrevino Sergio A · Houston, TXBuilt 1980 · S/N 18267680N5386ATriplett And Adams Transport Partnership LLC · New Concord, OHBuilt 1979 · S/N 21063406N5386BTop Dogs LLC · Dickinson, NDBuilt 1956 · S/N 33386N5386DDuffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1979 · S/N 17272559N5386JNaylor-Adams Aviation LLC · York, PABuilt 1980 · S/N 17273776N5386RVargo Michael D · Fremont, OHBuilt 1965 · S/N 17252921N5386SDodson International Parts Inc · Rantoul, KSBuilt 1967 · S/N 337-0486N5387CGoral William W · Redlands, CABuilt 1950 · S/N 15520N5387HStene Aviation Inc · Polson, MTFirst renewal noticeBuilt 1977 · S/N 18503330N5387KN5387k LLC · Carthage, NCBuilt 1980 · S/N 17274091N5387ROancea Traian · Oakdale, CAS/N 17252922N5387SGoyer Jeffrey A · Houston, TXBuilt 1966 · S/N 337-0487N5387TMagnusson Charles D · Upper Sandusky, OHBuilt 1964 · S/N 17251287N53885Gc Aviation Services-1 LLC · Miamisburg, OHBuilt 1981 · S/N 17274824N5388BBurak Steven W · Emmett, IDBuilt 1956 · S/N 33388N5388YValiair Lc Trustee · Casper, WYBuilt 1980 · S/N 21064190N5389CRegistration Pending · Niagara, WIRegistration pendingS/N 15522N5389DRegistered aircraftBuilt 1958 · S/N 50289N5389KMcconnell Cynthia D · New Smyrna Beach, FLBuilt 1980 · S/N 17274092N5389RTetrault David E · Largo, FLBuilt 1965 · S/N 17252925N5389TChadwell Letch J · Hulbert, OKBuilt 1964 · S/N 17251289N538CJav Air Services LLC · Anchorage, AKBuilt 1981 · S/N 17274724N538EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13078N538HFSun Aircraft Management LLC · Ormond Beach, FLBuilt 2000 · S/N 17280873N538KSKent State University · Stow, OHBuilt 2014 · S/N 172S11389N538NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10832N538PCFontaine Scott M · Salt Lake City, UTBuilt 1963 · S/N 18051328N538SPRc Flying Partners LLC · Fair Oaks, CABuilt 2000 · S/N 172S8395N538TBCorum Richard E Jr · Clemmons, NCBuilt 1963 · S/N 17249965N5390CGoebel Kendra S · Sarasota, FLBuilt 1950 · S/N 15523N5390E402wd Holdings LLC · Robstown, TXBuilt 1979 · S/N 18503961N5390NLarsen Steve J · Colton, ORBuilt 1980 · S/N 18267684N5390QIgnarro Jessie · Bay Shore, NYS/N 15073290
Back to AD 79-10-14 R1