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.

N736XBAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1978 · S/N R1722860N736XCEagle Squadron Inc · The Villages, FLBuilt 1978 · S/N R1722861N736XDRiverview Flyers LLC · Marysville, PABuilt 1978 · S/N R1722862N736XERegistered aircraftBuilt 1978 · S/N R1722863N736XHJlm Ranch Inc · Mullen, NEBuilt 1978 · S/N R1722866N736XMNorthwest Passage LLC · Anchorage, AKBuilt 1978 · S/N R1722870N736XNColorado Northwestern Community College · Rangely, COBuilt 1978 · S/N R1722871N736XSRegistration Pending · Urbandale, IARegistration pendingBuilt 1978 · S/N R1722875N736XVFreedom Aviation LLC · Riverton, UTBuilt 1978 · S/N R1722878N736XXMonteiro Aviation LLC · Minneapolis, MNBuilt 1978 · S/N R1722880N736XZPiotrowski Anthony J · Nanticoke, PABuilt 1978 · S/N R1722882N736YBCarlson James D · North Andover, MABuilt 1978 · S/N R1722884N736YDTrans World Aircraft LLC · Quakertown, PABuilt 1978 · S/N R1722886N736ZBMunning Gregory T Jr · Greensboro, NCBuilt 1978 · S/N R1722908N736ZWBrethren Pa LLC · Pittsburgh, PABuilt 1978 · S/N R1722927N73702Shiles Darrel J · Baltimore, MDBuilt 1976 · S/N 17267615N73707Leading Edge Flight Academy LLC · Bend, ORBuilt 1976 · S/N 17267620N7370ASunrise Aero Inc · Ocala, FLBuilt 1956 · S/N 29470N7370SNewman Carlon Keith · Cypress, TXBuilt 1976 · S/N 18265161N7370TVadakin Jeffrey M · Dover, DEBuilt 1959 · S/N 46970N7370XWilkerson Gale L · Paris, MOBuilt 1962 · S/N 15059470N7371Registered aircraftBuilt 1998 · S/N 18280212N73719Purdue Aviation LLC · West Lafayette, INBuilt 1976 · S/N 17267624N7371AArth Richard · Newcomerstown, OHBuilt 1956 · S/N 29471N7371MNagy Meserole Teresa A · Stevensville, MDBuilt 1958 · S/N 55671N7371NBradley Larry · Olustee, OKFirst renewal noticeBuilt 1974 · S/N 18263154N7371QHarbor Aviation LLC · Harbor Springs, MIBuilt 1972 · S/N 18261011N7371SJacobson Justin D · Fallon, NVBuilt 1976 · S/N 18265162N73726Wings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267630N73727Redtail Partners LLC · Moab, UTBuilt 1980 · S/N 20700617N73728Crowe Robert B · Del Valle, TXBuilt 1976 · S/N 17267632N7372GSky Cops LLC · Midland, TXBuilt 1973 · S/N 15074651N7372HLindholm Michael D · Anchorage, AKBuilt 1977 · S/N 18503378N7372MZavala Marco A · Phoenix, AZBuilt 1958 · S/N 55672N73732Midway Capital Aviation Inc · Orlando, FLBuilt 1976 · S/N 17267634N73733Muffett Pat D · Eastsound, WABuilt 1980 · S/N 20700618N73734Daro Norman E · Cody, WYBuilt 1976 · S/N 17267636N73735Martineau Aircraft Inc · Butte, MTBuilt 1976 · S/N 17267637N7373ABaker Thaddeus J · Elk, WAS/N 29473N7373EQuist Donald G · Ridgecrest, CABuilt 1960 · S/N 57073N7373MFarwell Linda B · Leavenworth, KSBuilt 1959 · S/N 55673N7373NPyne Jeffrey S · Spanish Fork, UTBuilt 1974 · S/N 18263156N7373QMidgette Damon · Santa Clarita, CAS/N 18261013N7373SSkiles Jere K · Narvon, PABuilt 1976 · S/N 18265164N7373UYr-Aircraft Leasing LLC · Bethel, AKBuilt 1977 · S/N 20700423N73742Adams Bruce M · Santa Fe, NMBuilt 1980 · S/N 20700619N73744Fca Flight Center Inc · Fitchburg, MABuilt 1976 · S/N 17267643N7374ASouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N A1500726N7374DBig E LLC · Lemoore, CABuilt 1979 · S/N 17272918N7374EWings As Eagles Mission Air Service Inc · Oshkosh, WIBuilt 1978 · S/N 17272098
Back to AD 79-10-14 R1