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.

N521SCHarrison Ted W · Grapevine, TXBuilt 1977 · S/N 21062343N521SDMedary Aviation LLC · Brookings, SDBuilt 2024 · S/N 172S13137N521TDRaiders-Tigers Flying Club · Houston, TXBuilt 1969 · S/N 17258636N521TKCato Air LLC · Wilmington, DEBuilt 2005 · S/N 18281673N521VTSeaplanes R Fun Inc · Wilmington, DEBuilt 1957 · S/N 50055N52200Pol Guillermo L · Miami, FLBuilt 1980 · S/N 17274433N52204Rench Eugene G · Owosso, MIS/N 18262452N52208Eastern Kentucky University · Richmond, KYBuilt 2002 · S/N 172S9208N5220AMarshall Chadwick J · Fort Walton Beach, FLBuilt 2002 · S/N 18281149N5220EMcgee Kirk S · Anchorage, AKBuilt 1959 · S/N 50520N5220FUnited States Air Force · Eglin Afb, FLBuilt 1965 · S/N 17253250N5220RChaz L Enterprises LLC · Ringwood, NJBuilt 1974 · S/N 17263434N52213Rosner Peter · Acton, MABuilt 1973 · S/N 18262457N52214Peterson Todd W · Beavercreek, ORBuilt 1973 · S/N 18262458N52217Mustang Sally Aviation LLC · Camden, SCBuilt 1980 · S/N 17274441N52218Jej Leasing LLC · Bangor, MEBuilt 1980 · S/N 17274442N52219Warren Flying Club Inc · Troy, MIBuilt 1980 · S/N 17274443N5221EAir Capital Aviators Club · Wichita, KSBuilt 1978 · S/N 17271778N5221RDunaway Jeffrey W · Bremerton, WABuilt 1974 · S/N 17263435N52220Meyer Jeffrey K · Osceola, WIBuilt 1980 · S/N 17274444N52225Robinett Douglas · Laguna Niguel, CABuilt 1973 · S/N 18262466N52226Kettell Merrilee · Eureka, MTBuilt 1973 · S/N 18262467N5222DRegistration Pending · Muncie, INRegistration pendingBuilt 1979 · S/N 17272456N5222ESmith Nathan C · Kenai, AKBuilt 1959 · S/N 50522N5222JFlywyo LLC · Kalispell, MTBuilt 1980 · S/N 17273738N5222RLebeouf Bros Towing LLC · Bourg, LABuilt 1976 · S/N 18503021N5222TRcs Services LLC · California, MDBuilt 1975 · S/N 33701655N52232Mustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10870N5223AGeneral Plumbing Inc · Walnut Creek, CABuilt 1979 · S/N 21063316N5223MGraham Holdings Inc · Atherton, CANon-citizen corporation, flight hours not reportedBuilt 2002 · S/N 20608180N5223QThealphamart LLC · Saint Petersburg, FLBuilt 1971 · S/N 15073123N5223RN5223r LLC · Opa Locka, FLBuilt 1974 · S/N 17263437N52241Christiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10879N52248Flight School Of Gwinnett · Lawrenceville, GABuilt 1981 · S/N 17274458N5224DMoreland Aviation Enterprises Inc · Byron, ILBuilt 1957 · S/N 50122N5224EFlight Training Aircraft LLC · Wilmington, DEBuilt 2008 · S/N 172S10875N5224FPfeiffer Logan A · Boonville, MOBuilt 1965 · S/N 17253263N5224GBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 172S9144N5224KAri Ben Aviator Inc · Fort Pierce, FLBuilt 1980 · S/N 17274018N5224NCasper James R · Decorah, IABuilt 1980 · S/N 18267581N5224QRiibe Gary J · Herman, NEBuilt 1971 · S/N 15073124N5224UNeil Anthony Foster Holdings LLC · Santa Rosa, CABuilt 1964 · S/N 206-0224N52250Lowcountry Flight LLC · Johns Island, SCBuilt 1980 · S/N 17274460N52251Sims Robert M · Mc Ewen, TNBuilt 1973 · S/N 18262485N52252Bos John D · Locust Grove, GABuilt 1980 · S/N 17274461N52253Blue Viking Enterprises LLC · San Jose, CABuilt 1973 · S/N 18262487N52255Springville Flying Club · Spanish Fork, UTBuilt 1973 · S/N 18262488N52256Hutchinson Scott N · Broadlands, VAS/N 18262489N5225DMustang Sally Aviation LLC · Camden, SCBuilt 1979 · S/N 17272457N5225ERowland Taylor · Wasilla, AKBuilt 1959 · S/N 50525
Back to AD 79-10-14 R1