OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,578

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.

N2393CKocon Tyler · Puyallup, WABuilt 1954 · S/N 30693N2393DSoares Manuel J · Wasilla, AKBuilt 1952 · S/N 20545N2393FGreengo Aviation LLC · Temple, TXBuilt 1965 · S/N 21058593N2393ZSky Training LLC · West Milford, NJBuilt 2000 · S/N 172S8596N2394DRegistration Pending · Fort Ripley, MNRegistration pendingBuilt 1952 · S/N 20546N2394FN2394 Fox LLC · Sapulpa, OKBuilt 1965 · S/N 21058594N2394XPierson Daniel · Kalispell, MTS/N 18256294N23959State Of Wisconsin · Madison, WIBuilt 2006 · S/N 18281748N2395RSweitzer Derrick L · Stewartstown, PAS/N 18255495N2395UBucher Sheldon L · Divide, COBuilt 1962 · S/N 17249995N2395XEdwards Keith D · Olathe, KSBuilt 1965 · S/N 18256295N2395YRice Dwight D · Loma Linda, CABuilt 1967 · S/N 17700195N2396DClark Patrick L · Kenai, AKS/N 20548N2396FFlippin Birds Aviation LLC · Mobile, ALBuilt 1965 · S/N 21058596N2396GLee James R · Hamilton, TXBuilt 1958 · S/N 51696N2396KWhitley Pat · Altoona, ALBuilt 2006 · S/N 18281750N2396RLucky Aviation LLC · Cincinnati, OHBuilt 1964 · S/N 18255496N2396UMurphy Brandon C · Portland, TNBuilt 1966 · S/N 15065077N2396YAulbur Carl A · Martinsburg, MOBuilt 1967 · S/N 17700196N2397DQuast George Walter · Hutchinson, MNBuilt 1952 · S/N 20549N2397GHargis William J · Covina, CABuilt 1958 · S/N 51697N2397RElevate Air LLC · Sandy, UTBuilt 1964 · S/N 18255497N2397SState Of Wisconsin · Madison, WIBuilt 1967 · S/N 337-0697N2397XDow Todd J · Wasilla, AKBuilt 1965 · S/N 18256297N2398DHenkelmann David H · Janesville, WIBuilt 1952 · S/N 20550N2398FHorizon Flying LLC · Wilmington, DEBuilt 1965 · S/N 21058598N2398SBowser Earle Stephen · Arcata, CABuilt 1967 · S/N 337-0698N2398XPerry Brian J · Stuart, FLBuilt 1965 · S/N 18256298N2399DAllison Clay M · San Angelo, TXBuilt 1952 · S/N 20551N2399FJordan Danny L · Medford, ORBuilt 1965 · S/N 21058599N2399GJohansson Ronny · Wasilla, AKBuilt 1958 · S/N 51699N2399YCarlson Carl E · Geneva, NYBuilt 1967 · S/N 17700199N239CSEversmeyer Larry D · Oklahoma City, OKBuilt 1950 · S/N 19555N239FGRidgeline Assets LLC · Wilmington, DEBuilt 2024 · S/N 172S13273N239KStick Ball Rudder LLC · Bonita Springs, FLBuilt 2022 · S/N 172S12829N239PD&J Training Planes LLC · Logan, UTBuilt 2004 · S/N 172S9613N239SPAvolant Aviation LLC · Mooresville, NCBuilt 1999 · S/N 172S8224N239TRosman Patrick R · Creston, WABuilt 1955 · S/N 31775N239TATextron Aviation Inc · Wichita, KSS/N 172S13613N239TXCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276463N239WMPlane Fun Inc Tr (Trustee) · Snellville, GABuilt 1953 · S/N 30383N23ADBoyd Kirby · Fort Worth, TXBuilt 1951 · S/N 20063N23ATCalifornia In Nice Inc · San Jose, CABuilt 1978 · S/N 17270997N23AZNix Jacob DBA · Johnson, KSBuilt 1974 · S/N 18502499N23CCulver Marc D · Anchorage, AKS/N 18256046N23CBNb Tweet And Sons · Nome, AKS/N 18503331N23CCMadrid Jorge M · Tucson, AZBuilt 1967 · S/N 185-1236N23CFYr-Aircraft Leasing LLC · Bethel, AKBuilt 1974 · S/N 20700276N23DBSky High Farmers LLC · Lakeville, MNBuilt 1975 · S/N 17264474N23DHOrtiz Guillermo · Puyallup, WABuilt 1975 · S/N 18264053
Back to AD 79-10-14 R1