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.

N91680Kay Scott Aviation Insurance Inc · Reno, NVBuilt 1969 · S/N 18259869N9168AMatthews Jeff M · Conowingo, MDS/N 18929N9168BAverett Joseph B · Denham Springs, LABuilt 1958 · S/N 36768N9168GClark Byron · Olympia, WABuilt 1971 · S/N 18260708N9168UC150 LLC · Gilbert, AZBuilt 1976 · S/N 15078119N91690Walker Curtis N · Phoenix, AZBuilt 1969 · S/N 18259872N91691Stumm Robert W · Cadott, WIBuilt 1969 · S/N 18259873N91699Caughlan Cody P · Santa Cruz, CABuilt 1969 · S/N 18259875N9169CVajdos Robert C Jr · Louise, TXBuilt 1955 · S/N 31268N9169GDodson International Parts Inc · Rantoul, KSBuilt 1971 · S/N 18260709N9169UVipperman Richard Madison Jr · Martinsville, VABuilt 1976 · S/N 15078120N9169XAllen Air LLC · Fennville, MIBuilt 1961 · S/N 18253569N916ACYr-Aircraft Leasing LLC · Bethel, AKBuilt 1979 · S/N 20700061N916ATKdrd Holdings LLC · Texas City, TXBuilt 1982 · S/N 17275931N916AVLopez Virgilio D · Brookshire, TXS/N 17272800N916BAMaya Aircraft Holdings LLC · Lee, NHBuilt 2002 · S/N 172S9116N916BQ9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12756N916CLDolphin Sales Inc · Wilkes Barre, PABuilt 1975 · S/N 17702273N916DFGasmire Charles · Frisco, TXBuilt 1975 · S/N 18264026N916ET9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12759N916FT9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12758N916GGSutton Aircraft Salvage LLC · Palmer, AKBuilt 1959 · S/N 52236N916GW9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12760N916HT9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12761N916KTPelican Flight Training LLC · San Carlos, CABuilt 2021 · S/N 172S12763N916MABusch Brett · Stanford, MTBuilt 1999 · S/N 172S8265N916MHHelmerich Jonathan D Jr · Tulsa, OKBuilt 1969 · S/N 17258177N916NT9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12762N916PBM & G Aircraft Management LLC · Aurora, ORBuilt 2021 · S/N 172S12765N916PYBragg Kris M · Embden, MEBuilt 1968 · S/N 17257159N916QTElizabeth City State University · Elizabeth City, NCBuilt 2021 · S/N 172S12766N916RR9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12767N916SEEiland James · Phenix City, ALBuilt 1977 · S/N 17269640N916TAAtp Aircraft 4 LLC · Wilmington, DES/N 17281076N916UT9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12768N916WCBarr Air Patrol LLC · Mesquite, TXBuilt 1980 · S/N U20605677N916WRPsl Surveys · Manassas, VAFirst renewal noticeS/N 18282262N91705Gerbick Dean · Lena, ILBuilt 1969 · S/N 18259878N9170APasqualino Carolyn G · Ocala, FLS/N 19361N9170BRegistration Pending · Shohola, PARegistration pendingBuilt 1958 · S/N 36770N91718Miklos Russ · Youngstown, OHBuilt 1969 · S/N 18259882N9171GKiehl Flying Service LLC · Winnett, MTBuilt 1973 · S/N 18801407TN9171HSonday Terrance · Spring, TXBuilt 1975 · S/N 17265990N9171MCarbon 182 LLC · Montgomery, TXBuilt 1976 · S/N 18264717N9171TLangmuir Circulation LLC · Perkasie, PABuilt 1959 · S/N 50671N91721Scott Dennis E · Wake Forest, NCBuilt 1969 · S/N 18259883N91722Ken-Oh Transportation LLC · Porter, INBuilt 1969 · S/N 18259884N91726Kcsi Aerial Patrol Inc · Bakersfield, CABuilt 1969 · S/N 18259886N9172AAndress Chad R · Casper, WYBuilt 1950 · S/N 19363N9172CBolinger Dean R · Bend, ORBuilt 1954 · S/N 31271
Back to AD 79-10-14 R1