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.

N96061Wold Wayne T · Wasilla, AKFirst renewal noticeS/N R1720089N9606BAnderson David R · Sycamore, ILBuilt 1957 · S/N 32903N9606GJack Leasing Services Inc · Duchesne, UTBuilt 1974 · S/N 18801556TN9606XRowland Douglas · Wichita, KSS/N 21057906N9607AAdams Teresa M Trustee · Granbury, TXBuilt 1949 · S/N 15328N9607HTwin Oaks Airpark Inc · Hillsboro, ORFirst renewal noticeBuilt 1975 · S/N 17266260N9607XBaldridge Steven J · Edmonds, WAS/N 21057907N9607YIsn Aviation LLC · Loup City, NEBuilt 1981 · S/N 21064559N9608GCopper River Airmotive LLC · Copper Center, AKBuilt 1972 · S/N U20601808N9608HCag Aircraft Holdings LLC · Crystal River, FLBuilt 1975 · S/N 17266261N9608QLahmers Melvin E · Newcomerstown, OHBuilt 1976 · S/N 17265693N9608XEsdaile Philip J · Woodland, CABuilt 1962 · S/N 21057908N9609QWestrup Gregory W · Greensburg, INBuilt 1975 · S/N 17265694N960AUAuburn University · Auburn, ALBuilt 2017 · S/N 172S12098N960CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281990N960FSSouthern Aero LLC · Homestead, FLBuilt 1974 · S/N 17263386N960MSMt San Antonio Community College District · Walnut, CABuilt 2001 · S/N 172S8859N960TAInnoutaero LLC · Stockton, CAS/N 172S8960N96100Trajectory Aviation LLC · Hollywood, FLBuilt 1983 · S/N 17276020N96105Demon Air LLC · Palm City, FLS/N 17276023N9610AJackson William P · Littlerock, CAS/N 15331N9610GChoice Aviation LLC · Hamilton, MTBuilt 1972 · S/N U20601810N9610QUS Aviation Group LLC · Denton, TXBuilt 1976 · S/N 17265695N9610TMulkey Randall L · Wellston, OKBuilt 1960 · S/N 57410N9610XSutton George E · Fullerton, CABuilt 1961 · S/N 21057910N9611HTarheel Aviators LLC · Cary, NCBuilt 1981 · S/N 18267972N9611XWinston Air LLC · Haleyville, ALS/N 21057911N9612AKm Aero Inc · Kalispell, MTBuilt 1949 · S/N 15333N9612G4-F Flyers LLC · Haysville, KSBuilt 1974 · S/N 18263408N9612HRegistration Pending · Ocean Isle Beach, NCRegistration pendingBuilt 1975 · S/N 17266263N9612RBearnose II LLC · Edina, MNBuilt 1985 · S/N U20606901N9613BLiebsch Mark W · Reno, NVBuilt 1957 · S/N 32910N9613GDavid W Easter Consulting Inc · Libby, MTBuilt 1972 · S/N U20601813N9613HFiedler Mark · Wichita, KSBuilt 1975 · S/N 17266264N9613TMilleman Barry M · Monticello, INBuilt 1960 · S/N 57413N9613ZAlosanel Charter Inc · Concord, NHFirst renewal noticeS/N U20606575N9614HC&H Elite Air LLC · Johnstown, COBuilt 1975 · S/N 17266265N9614QConrad Terry E · Lancaster, OHBuilt 1975 · S/N 17265699N9614TLucas Lester L · Napa, CABuilt 1960 · S/N 57414N9614XMountain Air Flying LLC · Brigham City, UTBuilt 1962 · S/N 21057914N9615ADay Michael J · Fort Wayne, INBuilt 1949 · S/N 15336N96167Westrum Durl Troy · Norwalk, IAS/N 55203N9616ELove James H · Springville, ALBuilt 1984 · S/N 18268429N9616LMid Island Air Service Inc · Ronkonkoma, NYBuilt 1986 · S/N 17276590N9616QClearview Flying Club Inc · Westminster, MDBuilt 1975 · S/N 17265701N9616XJim Barrett Photography Inc · Honolulu, HIBuilt 1961 · S/N 21057916N96177B2 Cpr Plus Inc · Bermuda Dunes, CABuilt 1970 · S/N 17701543N9617HShinn Lake D · Stevensville, MTBuilt 1976 · S/N 17266267N9617QKagin Corp · Wilmington, DEBuilt 1975 · S/N 17265702N9617ZWright William F Trustee · Anchorage, AKS/N U20606578
Back to AD 79-10-14 R1