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.

N9029XWichmann David · Park City, UTBuilt 1961 · S/N 18253429N902APPollard Aircraft Sales Inc · Fort Worth, TXBuilt 1998 · S/N 18280306N902AZSantiago Felipe · Miami, FLBuilt 1981 · S/N 17275091N902EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S12964N902FAVero Technical Support Inc · Pensacola, FLBuilt 1980 · S/N 17273785N902HMacvey Troy R · Milan, INBuilt 1971 · S/N 17259252N902KSSmart Aviation Solutions Inc · Lakeland, FLBuilt 1974 · S/N 15076244N902NSRegistration Pending · Pottstown, PARegistration pendingBuilt 1981 · S/N 17275415N9030ALimbach Cynthia S · Verona, ILBuilt 1949 · S/N 18785N9030RWilliams Transportation LLC · St Paul, MNBuilt 1967 · S/N 185-1244N9030TClark Joseph J · Fairbanks, AKBuilt 1960 · S/N 52930N9031AKiesling Michael J · Omro, WIBuilt 1949 · S/N 18786N9031UBlue Sky Aero Club Inc · Escondido, CABuilt 1977 · S/N 18265445N90322State Of Alaska Department Of Public Safety · Anchorage, AKS/N 20608323N9032AProag Services Inc · Mahnomen, MNBuilt 1949 · S/N 18787N9032MWillke Theodore Lawrence II · Tacoma, WAS/N 21062052N9032XWalters Douglas R · Sunbury, OHBuilt 1961 · S/N 18253432N9033AEverson David · Redding, CABuilt 1949 · S/N 18788N9033CPrice Tom Jr · Baker City, ORBuilt 1954 · S/N 31081N9033GHillside Air Service LLC · Roanoke, INS/N 18260573N9033MBasinger Robert C · Freedom, PABuilt 1976 · S/N 18264652N9034CGrizzly Air Service Inc · Paris, TXBuilt 1954 · S/N 31082N9034GDanielle K Heckman · Crystal River, FLBuilt 1971 · S/N 18260574N9034XCunningham Patrick J · Council Bluffs, IABuilt 1961 · S/N 18253434N9035GRd Smith LLC · Rexburg, IDBuilt 1971 · S/N 18260575N9036BVan Bortel Aircraft Inc · Arlington, TXBuilt 2010 · S/N 18282258N9036MChalk 2 Inc · Apple Valley, CABuilt 1977 · S/N 21062053N9036XNiemeyer Henry · Eagle River, AKS/N 18253436N9037MLevin Austin T Trustee · Prairie Du Sac, WIBuilt 1970 · S/N 18052137N9037XFornasier Manuel Jr · Westcliffe, COBuilt 1961 · S/N 18253437N9038CMackay Scott · Spokane Valley, WABuilt 1954 · S/N 31086N9038HPeterson Todd B · Cameron Park, CABuilt 1975 · S/N 17265912N90391Meyer Florence Trustee · Billings, MTBuilt 2010 · S/N 18282259N9039TMetal Bird LLC · West Jordan, UTBuilt 1960 · S/N 52939N9039XAhrens Videll A · Tintah, MNBuilt 1961 · S/N 18253439N903AZN903az LLC · Miami, FLBuilt 1984 · S/N 17276198N903CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8327N903KKHanger Nine Point Five LLC · Aztec, NMBuilt 1970 · S/N 33701263N903KSMbk Leasing And Consulting LLC · Lakeland, FLFirst renewal noticeBuilt 1975 · S/N 15076828N903NSAmerican Patrols Inc · Midland, TXBuilt 1976 · S/N 17267441N90404Liberty University · Lynchburg, VABuilt 2010 · S/N 172S11064N9040XAcme Air Venture Inc · Bristol, WIS/N 18253440N90419Goodhue Clinton H · Sidney, MEBuilt 1967 · S/N R172-0254N9042HSt Pete Aviation Services LLC · St Petersburg, FLS/N 17265914N9042QTumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 1976 · S/N 172-67996N9042TCase Rod E · Gold Hill, ORBuilt 1960 · S/N 52942N90432Knutson Wayne R · Thompson, NDFirst renewal noticeS/N 15070583N9043CHemphill Holdings LLC · Hemphill, TXBuilt 1954 · S/N 31091N9043HPinter Seth K · Abbotsford, WIBuilt 1975 · S/N 17265915N9043XKruger Bruce W · Gustavus, AKS/N 18253443
Back to AD 79-10-14 R1