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.

N4910UN4910u LLC · Cushing, OKBuilt 1965 · S/N 21058610N4911ASatra Jerry J · Sidney, MTBuilt 1956 · S/N 32308N4911CGianni David C · Fairbanks, AKBuilt 1975 · S/N 18502653N4911ESchumacher Gregory Luther · Anchorage, AKBuilt 1979 · S/N 18503904N4912EAdams Bruce M · Santa Fe, NMBuilt 1982 · S/N 18268284N4912GHardee Christopher D · Smyrna, TNBuilt 1979 · S/N 17273459N4913AOlson David J · Eugene, ORBuilt 1956 · S/N 32310N4913DRosies Procurement LLC · Midlothian, TXBuilt 1979 · S/N 17272395N4913GLeading Edge Flight Academy LLC · Bend, ORBuilt 1979 · S/N 17273460N4913UGarvey F Patrick · Churubusco, INBuilt 1965 · S/N 21058613N4914QGudgel Daniel R · Lemoore, CABuilt 1976 · S/N 18802649N4914UCaldwell Gregg P · Desert Hot Springs, CAFirst renewal noticeBuilt 1965 · S/N 21058614N4915CLang Carl R · Harper, TXBuilt 1975 · S/N 18502657N4916APerkins Larry L DBA · Lake Elsinore, CABuilt 1956 · S/N 32313N4916DHoward Dan E · Hurricane, UTBuilt 1958 · S/N 51016N4916FSkaggs Steven L · Winters, CABuilt 1966 · S/N U206-0616N4916GOngstad Anne Whitman · Robinson, NDBuilt 1979 · S/N 17273463N4917DWright Tyler C · Wilmington, NCBuilt 1958 · S/N 51017N4917GCarter Richard W · Bumpass, VABuilt 1979 · S/N 17273464N4917NHanging On The Prop LLC · San Tan Valley, AZBuilt 1979 · S/N 18267454N4918AMerrill Reese D · Brush Prairie, WAS/N 32315N4918QNauta Larry D · Soldotna, AKBuilt 1978 · S/N 18503575N4918UMission Aviation Fellowship · Nampa, IDBuilt 1979 · S/N U20605160N4918YGrathwohl Air LLC · Bloomfield Hills, MIBuilt 1980 · S/N 21064046N4919DDewitz Mark A · Good Thunder, MNBuilt 1958 · S/N 51019N4919FTice Denzil · Farmville, VABuilt 1979 · S/N 17273102N4919GRegistration Pending · Fairbanks, AKRegistration pendingS/N 17273466N4919NKoffeman Edward · Midlothian, TXBuilt 1979 · S/N 18267455N491ACEw Pegasus LLC · Walnut Creek, CAS/N 21063673N491AFMeyer Terry L · Wayne, NEBuilt 1968 · S/N 18258754N491CCBarbee Johnny Lee · Fort Stockton, TXBuilt 1971 · S/N 18260654N491EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12259N491SFSnohomish Flying Service Inc · Snohomish, WABuilt 2003 · S/N 172S9565N491SPLittle Rock Lsa Leasing And Rental LLC · Searcy, ARBuilt 1998 · S/N 172S8032N491WSDhs Operations LLC · Wilmington, DEBuilt 1999 · S/N 172S8305N4920ABerry Thomas R · Anchorage, AKBuilt 1956 · S/N 32317N4920GEye Candy Aviation LLC · Jacksonville, FLBuilt 1979 · S/N 17273467N4921AHogan William J · Libby, MTBuilt 1956 · S/N 32318N4921DMills Air Service Inc · Marstons Mills, MABuilt 1958 · S/N 51021N4921FCa Aviation 172 LLC · Santa Barbara, CAS/N U206-0621N4921RBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 18802438TN4921VFrumkin Mark Steven · Pittsburgh, PABuilt 1980 · S/N 172RG0416N4922DD Gordon Aviation Inc · La Jolla, CABuilt 1979 · S/N 17272398N4922GBishop Air LLC · Elk Grove, CABuilt 1979 · S/N 17273469N4922HOptic Air LLC · Maurice, IABuilt 1981 · S/N 18267853N4922VHhd Aviation LLC · Hamilton, OHBuilt 1973 · S/N 172RG0417N4922YHowey Aviation LLC · Woodhaven, MIBuilt 1980 · S/N 21064047N4923ADaniel Arthur D · Fishtail, MTBuilt 1956 · S/N 32320N4923CSmith Justin K · Wasilla, AKBuilt 1975 · S/N 18502659N4923DHarrier Aviation LLC · South Saint Paul, MNBuilt 1979 · S/N 17272399
Back to AD 79-10-14 R1