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.

N5661BPiekarski John G · Kuna, IDBuilt 1956 · S/N 33661N5661TSingletary Kenneth W · Newman Lake, WAS/N 17251561N5662AMccafferty John · East Jordan, MIBuilt 1956 · S/N 28262N5662BHollibird Aviation LLC · Knightdale, NCBuilt 1956 · S/N 33662N5662EFriendly Frogs LLC · Winona, MNS/N 17162N5663ETschirky Ted S · Pasco, WAS/N 17163N5664ASale Reported · Spirit Lake, IDSale reportedBuilt 1956 · S/N 28264N5665CWilson Thomas S · Fallbrook, CABuilt 1950 · S/N 15621N5665JFarwest Aviation LLC · Billings, MTBuilt 1970 · S/N 18800615N5665RLimmer Rita G · Redding, CABuilt 1965 · S/N 17253299N5666ARonshausen Steven A · Circleville, OHBuilt 1956 · S/N 28266N5666B98x LLC · Caddo Mills, TXBuilt 1956 · S/N 33666N5666EYakle Paul R · Lebanon, MOBuilt 1959 · S/N 17166N5666RSport Flying USA Inc · Ronkonkoma, NYBuilt 1965 · S/N 17253300N5667BMarmitt Management Inc · Moses Lake, WABuilt 1956 · S/N 33667N5667CClassic Aviation Inc · Pella, IABuilt 1950 · S/N 15623N5667EFolbre Frank S · Millsap, TXS/N 17167N5667KSmith John L · Renton, WABuilt 2001 · S/N 172S8991N5667RBrazos River Aviation Group LLC · Mineral Wells, TXBuilt 1965 · S/N 17253302N5668CMatthews Victor M · Comstock Park, MIBuilt 1950 · S/N 15624N5668EGreene Daniel W · Yuma, AZBuilt 1959 · S/N 17168N5668TShattuck Shaun R Jr · Coarsegold, CABuilt 1964 · S/N 17251568N5669ABlanchette Charles · Payson, AZBuilt 1956 · S/N 28269N5669CMorris Kenneth E · Poplar Grove, ILBuilt 1950 · S/N 15625N5669JWeber David A · Bryan, TXBuilt 1974 · S/N 18263486N5669RBeasley Marty J · Statesboro, GABuilt 1965 · S/N 17253304N5669TClemmons Gavin T · Hopkins, MNBuilt 1964 · S/N 17251569N566BGN566bg LLC · Leesburg, VABuilt 1979 · S/N 17272979N566CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 18283033N566DDeland Aviation LLC · Deland, FLBuilt 2007 · S/N 172S10529N566EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12878N566GSPomeroy Cattle Ranch LLC · Kalispell, MTS/N 15071446N566HCThomas Charles Stephen Trustee · Lakeway, TXBuilt 1981 · S/N 18267810N566JCMurphy Janel L · Lake Lure, NCBuilt 1977 · S/N 18265541N566JWRoss Stephen D · Greenfield, OHBuilt 1962 · S/N 18254448N566NDCoast Flight Training And Management Inc · San Diego, CABuilt 2008 · S/N 172S10804N566QButte Aviation Inc · Butte, MTBuilt 1979 · S/N 17273553N566RMBueter Eric · Wauseon, OHBuilt 1977 · S/N 18265722N566SPLlp Leasing Group LLC · Lewes, DEBuilt 2000 · S/N 172S8490N5670R&R Aircraft LLC · Chugiak, AKBuilt 1966 · S/N 18256905N5670BHart Deric C · Anchorage, AKBuilt 1956 · S/N 33670N5670JBank Of Utah Trustee · Salt Lake City, UTBuilt 1969 · S/N 18800620N5671AJarvis Peter S · Lebanon, CTBuilt 1956 · S/N 28271N5671BVaughn William · Charlotte, NCBuilt 1956 · S/N 33671N5671CBredin William B · Anchorage, AKS/N 15627N5672BToumala Scott R · Bemidji, MNBuilt 1956 · S/N 33672N5672GHarrold Adam T · New Waterford, OHBuilt 1969 · S/N 15071172N5673CBuzbee Nancy C · Mineral Wells, TXS/N 15629N5673EFarwell William B · Benton, PABuilt 1959 · S/N 17173N5674AStearns Edwin Ben Jr · Chandler, AZBuilt 1956 · S/N 28274
Back to AD 79-10-14 R1