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.

N61901Lalaguna Ricardo · Orlando, FLBuilt 1975 · S/N 17264880N6190CChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10741N6190DTap Solutions Inc · San Diego, CABuilt 1979 · S/N 17272623N6190RSundance Flying Club Inc · Palo Alto, CABuilt 1979 · S/N 172RG0110N61915Economy Flying Club Inc · Cusick, WABuilt 1975 · S/N 17264883N61919Tailspin LLC · Belle Chasse, LABuilt 1981 · S/N 18504274N6191BValiair Lc Trustee · Casper, WYS/N 34191N61922Chipman Roger M · Birch Harbor, MEBuilt 1975 · S/N 17264887N61923Northwoods Air LLC · Orono, MEBuilt 1975 · S/N 17264888N61925St Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1975 · S/N 17264890N61928Borszich Claude C · Phoenix, AZS/N 17264891N6192ECook Christopher M · Burnet, TXS/N 46292N6192KSmith Chris Sean · Pendleton, SCBuilt 1976 · S/N R1722034N6192NDolezal Todd R · San Luis Obispo, CABuilt 1978 · S/N 21062963N6192RAmbrosini Helicopters Inc · Fresno, CABuilt 1966 · S/N T210-0092N6192TAustin James M · Fort Worth, TXS/N 15060892N6192UKings Nw LLC · Lakewood, WABuilt 1979 · S/N U20605377N61933Geebee Ventures LLC · Belgrade, MTBuilt 1975 · S/N 17264894N61936Huffman David A · Oklahoma City, OKBuilt 1975 · S/N 17264897N61937Simplifly LLC · Mesa, AZBuilt 1975 · S/N 17264898N61938Davis Larry M · Rathdrum, IDBuilt 1977 · S/N 18052814N6193BSmith Brian R · Avon, CTBuilt 1957 · S/N 34193N6193CAirspeed Mammography Certifications LLC · Olympia, WABuilt 2008 · S/N 18282072N6193DDe Anza Building And Maintenance Inc · Los Altos, CAS/N 18281394N6193EHot Wingz LLC · Neeses, SCBuilt 1958 · S/N 46293N6193FRheinbolt John N · Highmore, SDBuilt 1968 · S/N 21059093N6193GHolcomb Jonathan Michael · Hollandale, MSRegistration expired, pending cancellationBuilt 1969 · S/N 15071693N6193MFreiesleben Thomas K · Brookfield, WIBuilt 2008 · S/N 18282058N6193RAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2008 · S/N 18282061N6193TAl Banna Emad R · Huntingtown, MDBuilt 1964 · S/N 15060893N61942Middle Village Enterprises LLC · Maspeth, NYBuilt 2008 · S/N 172S10772N61943Phoenix Composite Solutions LLC · Oscoda, MIBuilt 1975 · S/N 17264903N61946Straight And Level Aeromedical LLC · Billings, MTBuilt 1977 · S/N 18052815N61947Driggers Spencer A · Lake City, SCBuilt 1975 · S/N 17264906N6194BMaglaughlin Ronald D · Udall, KSFirst renewal noticeBuilt 1957 · S/N 34194N6194DBha Leasing Corp · South Portland, MEBuilt 1979 · S/N 17272626N6194EReeburgh Scott L · Vancouver, WABuilt 1978 · S/N 17271998N6194TFielden Larry · Sanger, CABuilt 1964 · S/N 15060894N6194VChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10771N61951Propability One LLC · Daytona Beach, FLBuilt 1975 · S/N 17264908N61953Smith Gregory D · Kalamazoo, MIBuilt 1975 · S/N 17264910N61955Tommys Flying Service Inc · Sherrill, ARBuilt 1981 · S/N 18504280N61958Hff Leasing LLC · San Diego, CABuilt 2008 · S/N 17281541N61959Scandinavian Aviation Academy Inc · El Cajon, CABuilt 2008 · S/N 17281542N6195BBoyd Edward Ayres · Coronado, CABuilt 1978 · S/N 21062705N6195EHedrick Harold F · New Port Richey, FLBuilt 1958 · S/N 46295N6195FRegistered aircraftBuilt 1968 · S/N 21059095N61960Dockins Jamie L · Athol, IDBuilt 1975 · S/N 17264917N61962Becker Jeremy R · Anchorage, AKBuilt 1975 · S/N 17264919N61963Grier Timothy R · Anchorage, AKBuilt 1981 · S/N 18504282
Back to AD 79-10-14 R1