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.

N4715DPetracca Carmine J · Lewiston, IDBuilt 1957 · S/N 34815N4715FRegistration Pending · Ukiah, CARegistration pendingBuilt 1966 · S/N P206-0315N4715JClarke Brent H · Neversink, NYS/N 17273666N4715KSki Town Aviation Management LLC · Steamboat Springs, COBuilt 1975 · S/N 18263714N4715XBlair Ross Iain · Milford, NJBuilt 1966 · S/N 15064765N4716BClose Keith · Anchorage, AKBuilt 1955 · S/N 31614N4716DDavenport Reginald · Evans, WABuilt 1957 · S/N 34816N4716KGlobal Acquisition Ltd · Davenport, IABuilt 1975 · S/N 18263715N4716NHolcombe Aaron L · Jay, OKBuilt 1979 · S/N 18267305N4716XJessup Sheila · Dublin, CABuilt 1980 · S/N U20605527N4717CCt Aviation LLC · Fort Worth, TXBuilt 1979 · S/N 21063598N4717NHaagenson Jeffrey M · Portland, ORS/N 18267306N4718BMartin Nathaniel W Trustee · Wasilla, AKBuilt 1955 · S/N 31616N4718DAviation Of North Florida LLC · Jacksonville, FLBuilt 1958 · S/N 34818N4718FPbar Inc · Joseph, ORBuilt 1966 · S/N P206-0318N4718KMayes John · Carson City, NVS/N R1722017N4718NL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 1979 · S/N 18267307N4718XRobb James W · Uhrichsville, OHBuilt 1966 · S/N 15064768N4719FFrederick Joel · Hobe Sound, FLBuilt 1979 · S/N 17273076N4719KOneninekilo LLC · West Linn, ORBuilt 1975 · S/N 18263718N471BCHyndman Antonio · Canton, TXBuilt 1976 · S/N 18264591N471EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2018 · S/N 172S12193N471JROrtiz Rivera Jose E · Bayamon, PRBuilt 1972 · S/N 17260933N471MRAdvanced Aviation Group LLC · Frederick, MDS/N 17281078N471PRRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1973 · S/N 17262016N471SPPine Ventures LLC · Malmo, NEBuilt 1998 · S/N 172S8014N471TMAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13471N472Custer Charles D · Destin, FLS/N 205-0476N4720CNesbit Gary M · West Linn, ORBuilt 1979 · S/N 21063601N4720KGeorge Joseph Q · Granbury, TXBuilt 1975 · S/N 18263719N4720QFielding William J IV · Scarborough, MES/N 185-1174N4720RHotkeys Holding LLC · Silver Spring, MDBuilt 1979 · S/N 172RG0016N4720YKraemair Aviation LLC · Sauk City, WIBuilt 1980 · S/N 21063992N4721DCarm'S LLC · Beaver Springs, PAS/N 34821N4721NRegistered aircraftBuilt 1979 · S/N 18267310N4721QXtreme Attitudes LLC · Sanford, NCBuilt 1966 · S/N 185-1175N4721RWaterdawg Express LLC · Pocatello, IDBuilt 1979 · S/N 172RG0017N4721UBartlow Amos · North Pole, AKBuilt 1964 · S/N 18051421N4722BHill James P · Eagle Point, ORBuilt 1955 · S/N 31620N4722FStoskopf Scott W · El Dorado, KSBuilt 1966 · S/N P206-0322N4722UBlackmon Peter G · Anchorage, AKS/N 18051422N4723FStraightin LLC · Paauilo, HIBuilt 1966 · S/N P206-0323N4723NNorth Central Aircraft LLC · Blaine, MNBuilt 1979 · S/N 18267312N4723RSmolkin Alexander S · North Chesterfield, VABuilt 1979 · S/N 172RG0018N4723YRegina Air Cargo Corp · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1980 · S/N 21063993N47249Farnsworth Erwin L · Anchorage, AKBuilt 1959 · S/N 50464N4724BSchlink Richard L · Soulsbyville, CABuilt 1955 · S/N 31622N4724KWalgrove Venice LLC · Santa Monica, CABuilt 1975 · S/N 18263723N4724QDehart T James Trustee · Kalama, WABuilt 1978 · S/N 18503550N4724XFlying My Dreams LLC · Miami Gardens, FLS/N 15064774
Back to AD 79-10-14 R1