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.

N53103Top Flight Aerial Photography LLC · Georgetown, TXBuilt 1978 · S/N 177RG1347N53105Pence Dale E · Garnett, KSBuilt 1974 · S/N 18801625TN53107Pea-Wayman Flight LLC · Daytona Beach, FLS/N 17274684N53108Prindle Steven G · Seaford, DEBuilt 1978 · S/N 177RG1348N5310DD & S Aviation LLC · Spring, TXBuilt 1979 · S/N 17272508N5310ENeiman Enviroments Inc · Junction, TXBuilt 1983 · S/N 18268310N53116Wnc Aviation LLC · Arden, NCBuilt 2002 · S/N 172S9283N5311CBudde Bobby M Jr · San Jose, CABuilt 1950 · S/N 15431N5311HBas Part Sales LLC · Greeley, COBuilt 2002 · S/N 172S9278N5312CLemanski Joseph S · Grosse Ile, MIBuilt 1950 · S/N 15432N5312HSkywarrior Flight Training Inc · Pensacola, FLBuilt 1975 · S/N 17265400N5312KDelta State University · Cleveland, MSBuilt 2003 · S/N 17281143N5312SGace Flying Club · Ronkonkoma, NYBuilt 2002 · S/N 172S9285N5312VBounds Justin M · Houston, TXBuilt 2003 · S/N 172S9287N53134Sundog Logistics LLC · Lenexa, KSBuilt 1981 · S/N 17274691N5313CSlater John · Saint Charles, ILBuilt 1950 · S/N 15433N5313NGavin Patrick H · Carlsbad, CABuilt 1980 · S/N 18267640N5313TDingman James B · Spencerville, INS/N 17251213N5313USky Quest 210 LLC · Clarksdale, MSBuilt 1984 · S/N 21064862N53143Delta State University · Cleveland, MSBuilt 2003 · S/N 17281145N53147Cloud Cappers Flying Club Inc · Salisbury, NCBuilt 1981 · S/N 17274693N5314E57d Flyers LLC · Shelby Township, MIBuilt 1978 · S/N 17271835N5314KLaporte Aviation Services Inc · La Porte, INBuilt 1980 · S/N 17274060N5314QN5314q LLC · Titusville, FLBuilt 1972 · S/N 15073214N5314RDelta State University · Cleveland, MSBuilt 2003 · S/N 17281144N5314TWynot Aviation LLC · Riverton, WYBuilt 1964 · S/N 17251214N5314VBurke Sterling M · Olympia Fields, ILBuilt 1975 · S/N 21060905N5314XMoody Bible Institute Of Chicago · Spokane, WAS/N U20605633N53152Griffin Bruce H · Trenton, FLBuilt 1978 · S/N 177RG1352N53158Schoen William R · Madison, CTS/N 177RG1353N5315BBrady Brian O · Kirkland, WAS/N 33315N5315EEastern Cincinnati Aviation Inc · Batavia, OHS/N 172S9291N5315QLessig Bruce D · Casper, WYBuilt 1972 · S/N 15073215N5315SDejean Karl J · Colorado Springs, COBuilt 1966 · S/N 337-0415N5315TLocal Flight Adventures LLC · Morgantown, WVBuilt 1964 · S/N 17251215N5315XAtarah LLC · Tucson, AZBuilt 1980 · S/N U20605634N53160Benson Michael H · New Castle, PABuilt 1978 · S/N 177RG1354N5316DErickson Todd E · Wasilla, AKBuilt 1958 · S/N 50214N5316GBerg Philip L · Chatsworth, CAS/N 172S9294N5316RTraining Planes LLC · Tampa, FLBuilt 1979 · S/N 172RG0053N5316THavre Flying Club Inc · Havre, MTBuilt 1964 · S/N 17251216N53170Price Brian · Page, AZS/N 25861N53175Kendall Investment Corp · Three Lakes, WIFirst renewal noticeS/N 177RG1357N53176Perfect Agreements Leasing Inc · Trabuco Canyon, CAS/N 172S9299N5317ABlue Skies Air LLC · Allen, TXBuilt 1979 · S/N 21063365N5317BWilson Bach M · Piedmont, SCBuilt 1956 · S/N 33317N5317CLiverett Herb · Rio Linda, CABuilt 1950 · S/N 15437N5317DMonroe City Aviators LLC · Palmyra, MOBuilt 1979 · S/N 17272513N5317HHottel Cessna LLC · Prescott, AZBuilt 1975 · S/N 17265401N5317KN5317k Corp Trustee · Wilmington, DEBuilt 1980 · S/N 17274061
Back to AD 79-10-14 R1