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.

N739ZCP&B Aviation LLC · Watkins, COBuilt 1978 · S/N 17270928N739ZGR & R Aero Services Llcc · Eden Prairie, MNBuilt 1978 · S/N 17270932N739ZHFreeflight Aviation LLC · Allentown, NJBuilt 1978 · S/N 17270933N739ZLLefebvre Jeffrey S · Kaneohe, HIBuilt 1978 · S/N 17270936N739ZNOur Jett LLC · Englewood, COBuilt 1978 · S/N 17270938N739ZPBlue Sky Aviation LLC · Watkins, COBuilt 1978 · S/N 17270939N739ZSPryor James A · Bottineau, NDS/N 17270942N739ZUMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17270944N739ZWHolladay Aviation LLC · Jacksonville, FLBuilt 1978 · S/N 17270946N739ZXN739zx Flying Association · Kent, WABuilt 1978 · S/N 17270947N739ZZR & R Aero Services LLC · Eden Prairie, MNBuilt 1978 · S/N 17270949N73ALHefel Lori A · Wichita, KSBuilt 1974 · S/N 177RG0559N73BJJewett Brandon M · Brighton, COBuilt 1975 · S/N 18502798N73BTDragging Tails LLC · Colbert, GABuilt 1965 · S/N 18051606N73CHAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13234N73CQHillesheim Steven T · Grass Valley, CABuilt 1958 · S/N 51251N73CYRti Fabrication Inc · Plains, MTS/N U20606815N73DAFlying Alaska LLC · Anchorage, AKS/N 185-0119N73EKOgrin Kirk W · Bigfork, MTBuilt 1978 · S/N 18503464N73ESWilmington Trust Co Trustee · Wilmington, DEBuilt 2019 · S/N 18283074N73FRWayman Luy LLC · Weston, FLBuilt 1979 · S/N 17273134N73GJSkydive Greene County Inc · Xenia, OHBuilt 1958 · S/N 51359N73GLG & N Enterprises LLC · Sparks, NVBuilt 1972 · S/N 18261599N73GMPrice Roger Paul · Punta Gorda, FLBuilt 1973 · S/N 18262679N73JJJj Ventures LLC · Billings, MTBuilt 1981 · S/N 18504241N73JKGolden Jerry W · Ocean Springs, MSRegistration ineffective or invalidBuilt 1966 · S/N 15064948N73LHerald Gregory L · Coatesville, INBuilt 1963 · S/N 17250283N73LLT3 Aviation LLC · Oak Point, TXBuilt 1977 · S/N 21062163N73LT302 LLC · Anchorage, AKBuilt 1957 · S/N 32823N73MHRainier Flight Service LLC · Renton, WABuilt 2023 · S/N 172S13003N73MRMarshall Edward G Trustee · Saint Clair, MIS/N 18282391N73MSJohnson Kevin N · Bethpage, NYBuilt 1977 · S/N 17268932N73PRegistered aircraftS/N 18262052N73PPArew Aviation LLC · San Tan Valley, AZS/N 17261627N73PWWarren John M · El Paso, TXBuilt 1971 · S/N 17259809N73RBTurbo Centurion LLC · North Salt Lake, UTS/N 21061758N73RJRichard Kent A · Sunset, LABuilt 1966 · S/N 15062833N73SC73sc Owners Group Inc · Torrance, CABuilt 1965 · S/N 18256623N73TAWorks Design Group Inc · Hammondsport, NYBuilt 2017 · S/N 18283005N73TFKlanchar Flying LLC · Benton, ARBuilt 1966 · S/N 17255638N73TLTeaff Leslie T Trustee · Russellville, ARBuilt 1999 · S/N 18280657N73TPTop Aircraft Leasing LLC · Wilmington, DES/N 34665N73WPGemini 3 LLC · Cleves, OHS/N 17268849N740United States Department Of Interior · Boise, IDBuilt 1980 · S/N U20605724N7400AHarrop Brian C · Mesa, AZBuilt 1957 · S/N 29500N7400M7400m Air Inc · Auburn, ALBuilt 1958 · S/N 55700N7400XLandrush Construction LLC · Fairview, OKBuilt 1960 · S/N 17247900N7401ECosta Air Service LLC · Painted Post, NYBuilt 1959 · S/N 57101N74022Braatz Cannonf · Bend, ORBuilt 1958 · S/N 50324N7402QRichs Alaskan Flying Adventures LLC · Wasilla, AKBuilt 1973 · S/N U20602192
Back to AD 79-10-14 R1