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.

N7316QAirborne LLC · Wilmington, DEBuilt 1972 · S/N 18260956N7316XMattson Nicholas R · Vail, AZBuilt 1961 · S/N 15059416N73170Jahawk Leasing LLC · Sugar Grove, ILBuilt 1976 · S/N 17267297N73171Jettmar Rainer U · Washington, DCBuilt 1976 · S/N 17267298N73172American Patrols Inc · Midland, TXBuilt 1976 · S/N 17267299N73174Welch Cleatus E · Orlando, FLBuilt 1976 · S/N 17267301N73178G P Holding Inc · Mora, MNBuilt 1976 · S/N 17267305N73179Weengknutts 179 · Delta, UTS/N 17267306N7317GSettles Lauren E · Owensboro, KYBuilt 1970 · S/N 17259017N7317SGoodman Jack A · Memphis, TNBuilt 1976 · S/N 18265109N73181Nurse Alex S · San Diego, CABuilt 1976 · S/N 17267308N73182Savannah Airplanes Venture LLC · Myrtle Beach, SCBuilt 1973 · S/N 18261434N73183Sandwich Aviation Inc · Somonauk, ILBuilt 1976 · S/N 17267310N73189Ellie Air LLC · Mabank, TXBuilt 1976 · S/N 17267316N7318GMay Curtis · Joplin, MTBuilt 1970 · S/N 17259018N7318HMichaud Francis G · Marine St Crx, MNBuilt 1977 · S/N 18503359N7318MOttis David J · Norfolk, NES/N 55618N7318SStahl K Joseph · Gainesville, TXBuilt 1976 · S/N 18265110N73190Flying J Enterprises LLC · San Antonio, TXBuilt 1976 · S/N 17267317N73192Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1976 · S/N 17267319N73195Saratoga Flyers Inc · South Glens Falls, NYBuilt 1976 · S/N 17267322N73197Seward Kent · Parma, IDBuilt 1976 · S/N 17267324N73198Davis Jimmy R Jr · Wharton, TXBuilt 1976 · S/N 17267325N73199Performance Polymer Technologies LLC · Roscommon, MIBuilt 1976 · S/N 17267326N7319AHart George · Yuba City, CAS/N A1500712N7319DN7319d LLC · Port Saint Lucie, FLBuilt 1979 · S/N 17272913N7319GPiguzov Yevgeniy · Hillsborough, NJBuilt 1970 · S/N 17259019N7319MCordes Hannah K · Winthrop, WABuilt 1958 · S/N 55619N7319QBassett Robert C · Gypsum, COBuilt 1972 · S/N 18260959N731AALandis Lloyd B · Ardmore, OKBuilt 1970 · S/N 182-60331N731ABA & C Ag Aviation Inc · Unadilla, GABuilt 1976 · S/N 18802735TN731BGKutschera Theodore C DBA · Callicoon, NYBuilt 1976 · S/N 18802763TN731BMBenaiah Holdings Corp · Marion, KYS/N 18802768TN731CENoe Aviation LLC · Vinton, IABuilt 1976 · S/N 18802785TN731CLNby Productions · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 18282256N731CQD & K Aviation Inc · Milford, IABuilt 1977 · S/N 18802794TN731ECFitchett Bradley S DBA · Ellsworth, KSS/N 18802830N731EQUnited States Department Of Agriculture · Edinburg, TXBuilt 1976 · S/N 18802843TN731ESSky Tech Inc · Dorchester, NES/N 18802845TN731FMNew Frontier Aviation LLC · Fort Benton, MTBuilt 1977 · S/N 18802862TN731FPLihs Ryan J · Sioux City, IABuilt 1977 · S/N 18802864TN731GDRegistration Pending · Walnut, ILRegistration pendingBuilt 1977 · S/N 18802877TN731GPUpshaw John L Jr · Claude, TXBuilt 1977 · S/N 18802887TN731GTDigger Dougs Crop Dusting Services Inc · Hollandale, WIBuilt 1977 · S/N 18802891TN731KWVann Dudley C DBA · Greenville, NCBuilt 1977 · S/N 18802963TN731LACmk Aerial Inc · Sutton, NEBuilt 1977 · S/N 18802967TN731LFMcneill Dudley T · Happy, TXS/N 18802972N731MCFalk Arthur J · Southport, NCS/N 18265598N731MJLake Chelan Helicopters LLC · Manson, WABuilt 1974 · S/N U20602362N731MKMccormick Eugene C DBA · Tyler, ALS/N 18802999T
Back to AD 79-10-14 R1