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.

N7726FWargacki Darrin W · Hamilton, OHBuilt 1966 · S/N 15063826N7726XTop Profile Management LLC · Somis, CABuilt 1960 · S/N 17248226N7727GSkyhawk Air LLC · Brunswick, GABuilt 1970 · S/N 17259427N7727UWingtip Aviation LLC · Amarillo, TXBuilt 1964 · S/N 17251727N7728GTakeflight LLC · Spanish Fork, UTBuilt 1970 · S/N 17259428N7728UKropp Richard G · North Creek, NYBuilt 1964 · S/N 17251728N7729EMaldonado Abel N · Santa Maria, CABuilt 1959 · S/N 17529N7729FCardenas Enrique · Brownsville, TXBuilt 1966 · S/N 15063829N7729GValiair Lc Trustee · Casper, WYBuilt 1970 · S/N 17259429N7729UBlough Lynn M · Pittsburgh, PABuilt 1964 · S/N 17251729N772CGBarefoot Brendan · Four Oaks, NCBuilt 1973 · S/N 18261964N772FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13277N772GKAmerican Aircraft Brokers LLC · Aurora, ORBuilt 2005 · S/N 172S9885N772KWTime Flies LLC · Loxahatchee, FLS/N R1722854N772MABaumbaugh Randal Kelly · Granger, INBuilt 1978 · S/N R1722959N772MSSchmidt Barnet M · Oradell, NJBuilt 1999 · S/N 172S8180N772MVAir And Sea LLC · Oak Bluffs, MAS/N R1722823N772PLSfc-182 LLC · Kansas City, MOBuilt 1965 · S/N 18255970N772RAKehmeyer Aviation LLC · Bronson, MIBuilt 1977 · S/N 17270013N772RFSpencer John S · Indian, AKBuilt 1967 · S/N U206-0816N772TXDyson Thornton E · Houston, TXBuilt 1979 · S/N 18267491N772ZZCirri Joseph A · Deming, NMBuilt 1966 · S/N 15064240N7730FBmg Aviation Leasing LLC · Bloomington, INBuilt 1966 · S/N 15063830N7730GSellet Jack A · Winter Haven, FLBuilt 1973 · S/N 15074719N7731FN7731f LLC · Portage, MIBuilt 1966 · S/N 15063831N7731KMorrison Richard Trustee · Anchorage, AKBuilt 1976 · S/N 18052712N7731TNash Leslie W · Bentonia, MSBuilt 1960 · S/N 47331N7731UMd Aviation Inc · Sioux Falls, SDBuilt 1964 · S/N 17251731N7731VDedmon Stephen V · Fleming Island, FLBuilt 1976 · S/N 177RG0906N7732XLinstad Daniel E · Canby, ORBuilt 1960 · S/N 17248232N7733GWashingtons Mt St Helens Co Inc · Mill Creek, WAS/N 17259433N7733TSiu Ena · Reno, NVS/N 47333N7733UGutlon Richard S · Durham, NCBuilt 1964 · S/N 17251733N7733VLong Final LLC · Clay, NYBuilt 1976 · S/N 177RG0907N7734ERegistration Pending · Cheyenne, WYRegistration pendingBuilt 1959 · S/N 17534N7734FJackson Kimberly F · Wichita Falls, TXBuilt 1966 · S/N 15063834N7734XNelson Daniel J · Ladd, ILBuilt 1961 · S/N 17248234N7735GShaver John M · Shelby, NCBuilt 1973 · S/N 15074722N7736GKnudson Aviation LLC · Bozeman, MTS/N 17259436N7736LSimmons David · Fremont, NEBuilt 1976 · S/N 17702603N7736UWatson Marshall · Sublette, KSS/N 17251736N7736XSutton Aircraft Salvage LLC · Palmer, AKBuilt 1960 · S/N 17248236N7737FChapman John · San Antonio, TXBuilt 1966 · S/N 15063837N7737UMast Elroy T · Crawford, MSBuilt 1964 · S/N 17251737N7738EKrueger Arthur G · Cottonwood, CABuilt 1959 · S/N 17538N7738GCurioso Enrique Martin · Irvine, CAFirst renewal noticeS/N 17259438N7738UGibson Nathaniel A · Cross Lanes, WVBuilt 1964 · S/N 17251738N7738XSutter William R · Hobart, WAS/N 17248238N7739GFlyguys 172 LLC · Liberty, NCBuilt 1970 · S/N 17259439N773AAAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13476
Back to AD 79-10-14 R1