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.

N7770UBrown Michael E · Miramar, FLBuilt 1964 · S/N 17251770N7771AWells Jason R · Chugiak, AKBuilt 1956 · S/N 32668N7771BBeam Thomas W · Paw Paw, MIBuilt 1964 · S/N 17251607N7771EEchanove Michael · Palouse, WABuilt 1959 · S/N 17571N7771GEmpire Aero Club Inc · Sebastopol, CABuilt 1970 · S/N 17259471N7771TBailey Bradley E · Phoenix, AZBuilt 1960 · S/N 47371N7771UPryor Isaac L · Charlotte, NCBuilt 1964 · S/N 17251771N7772BLunken Martha F · Cincinnati, OHBuilt 1956 · S/N 32420N7772FCushing Aviation LLC · Red Wing, MNBuilt 1966 · S/N 15063872N7772GWings Over Texas Holdings LLC · Denton, TXBuilt 1970 · S/N 17259472N7772UKiger Aviation LLC · Corvallis, ORBuilt 1964 · S/N 17251772N7772WWadhwa Anil Jethanand · Clarksville, TNBuilt 2004 · S/N 18281336N7772XPremier Air Inc · Raceland, LABuilt 1961 · S/N 17248272N7773FDux Aaron T · Missoula, MTS/N 15063873N7773TBennett Kevin S · Bay City, ORBuilt 1960 · S/N 47373N7773UWitsberger Kelly R · Newburg, MOBuilt 1964 · S/N 17251773N7774ASaydun LLC · Richardson, TXBuilt 1964 · S/N 17252168N7774BAdair Aviation LLC · Broken Arrow, OKBuilt 1981 · S/N U20606224N7774FMurphy Jeffrey R · Newport, MNS/N 15063874N7774GElliott Miles · Porterville, CABuilt 1970 · S/N 17259474N7775GMondragon Vidahk D · Reseda, CAFirst renewal noticeBuilt 1970 · S/N 17259475N7775KMarsh John E · Washington, DCS/N 18053071N7775TSheaffer Hayden L · Lititz, PABuilt 1960 · S/N 47375N7776EOtte Bowdie · Norfolk, NEBuilt 1959 · S/N 17576N7776GGulf Atlantic Airways Inc · Gainesville, FLBuilt 1970 · S/N 17259476N7776HAcevedo Adriel · San Antonio, TXBuilt 1976 · S/N 21061194N7776XVista I Inc · Smithville, OHBuilt 1961 · S/N 17248276N7777ALibby Stephen R Trustee · Anchorage, AKBuilt 1978 · S/N U20604391N7777CSouthern Sky LLC · Henderson, NVBuilt 1976 · S/N 17267334N7777SHood Company LLC · Nashville, TNBuilt 1972 · S/N 21059611N7778Carpenter Darrell W · Midland City, ALBuilt 1973 · S/N 177RG0349N7778UAngel Del Mar LLC · Park City, UTBuilt 1964 · S/N 17251778N7779AHendry Rickey W · Apple Springs, TXBuilt 1956 · S/N 32676N7779FSmith Brian · Richmond, INBuilt 1966 · S/N 15063879N7779KSeventy Six Juliet LLC · Oakland, CABuilt 1976 · S/N 18052728N777ADLeithead Bruce O · Stone Mountain, GABuilt 1958 · S/N 55502N777AHJarhead Aviation LLC · Port Saint Lucie, FLBuilt 1973 · S/N 17261695N777BMJet Air Of South Florida Inc · Deerfield Beach, FLBuilt 1978 · S/N 21063156N777CASwamp Skies LLC · North Miami, FLS/N 17268259N777CFCp Aviation LLC · Pasco, WABuilt 1977 · S/N 21062059N777DUSc Infinities LLC · Dover, DEBuilt 1971 · S/N 17259854N777FWLewis Kent · Lake Oswego, ORBuilt 1974 · S/N 21060167N777GTShillings Phillip J · Goldthwaite, TXS/N 21058339N777HEUsoarflorida LLC · Fort Myers, FLS/N 172S8120N777HKPremiere Aviation LLC · Evansville, INBuilt 1976 · S/N 18265047N777HMMusser Harold R · Cody, WYBuilt 1980 · S/N 18504048N777HRLansing Skylane Inc · Orland Park, ILBuilt 1981 · S/N 18267963N777HSJohnson Erik L · Long Beach, CABuilt 1975 · S/N 21060835N777JKGeoterra Inc · Eugene, ORS/N 21064714N777KSBrahm Robert D · Mercer Island, WABuilt 1978 · S/N 18266736
Back to AD 79-10-14 R1