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.

N641JMDubose Mack H · Edmonds, WAS/N 20608024N641MRoyo Marco · Canutillo, TXBuilt 1976 · S/N 21061641N641NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2015 · S/N 172S11615N641SPRhode Island Air LLC · Providence, RIS/N 172S8049N641TAAk Leasing LLC · Orchard Lake, MIBuilt 1978 · S/N 18266599N641THN641th Corp · La Quinta, CABuilt 2021 · S/N 172S12641N64201Registration Pending · Lander, WYRegistration pendingBuilt 1975 · S/N 17265083N64203Vance Nicholas D · Bluffton, OHS/N 17265084N64205Mulligan George G Trustee · Friday Harbor, WABuilt 1977 · S/N 18052880N64209Kay Roland C · Wasilla, AKS/N 17265090N6420AAbidance Inc · Winthrop, WABuilt 1956 · S/N 33220N6420FWilson Christopher Derrick · Ovilla, TXBuilt 1966 · S/N 15063020N6420NSouth Aero LLC · Albuquerque, NMBuilt 1981 · S/N 18504307N6420VKorson James · Yorkville, ILBuilt 1980 · S/N 172RG0681N6420XHarmon Jeremy Scott · Ely, MNBuilt 1960 · S/N 18050920N6420YFlying Amigos Aviation LLC · Las Cruces, NMBuilt 1981 · S/N 21064370N64211Miller Paul F · Whitefish, MTBuilt 1977 · S/N 18052881N64213Ajc Aviation LLC · Boca Raton, FLBuilt 1975 · S/N 17265093N64215Registered aircraftBuilt 1975 · S/N 17265095N64217Simplifly LLC · Mesa, AZBuilt 1975 · S/N 17265097N64219American Patrols Inc · Midland, TXBuilt 1975 · S/N 17265098N6421AAllen Khaled Charles · Berkeley, CABuilt 1956 · S/N 33221N6421BNord Andrew E · West Columbia, SCBuilt 1956 · S/N 29621N6421EOsborn Jon C · Groveland, FLBuilt 1959 · S/N 46521N6421FBixby Paul A · Vale, ORBuilt 1966 · S/N 15063021N6421SKnutson Wayne R · Thompson, NDBuilt 1967 · S/N 15067221N6421TOlmstead Richard M · Grand Rapids, MIS/N 17821N6421XDinstel Delbert F · Park City, MTBuilt 1960 · S/N 18050921N6421YHulett Gregory · Las Vegas, NVBuilt 1981 · S/N 21064371N64220Wieman Dianne L · Marion, TXBuilt 1975 · S/N 17265099N64224Smith Aviation LLC · Springer, OKBuilt 1975 · S/N 17265103N64228Abbott Cedric M · Buckfield, MEBuilt 1975 · S/N 17265105N6422AColby Clayton L · Kalispell, MTBuilt 1956 · S/N 33222N6422FClark James H · Pittsfield, MABuilt 1966 · S/N 15063022N6422KOvist Gregg · Phoenix, AZS/N 15077696N6422TRegistration Pending · Vidalia, LARegistration pending, pending cancellationBuilt 1959 · S/N 17822N6422XHawley Lorna M · East Troy, WIBuilt 1960 · S/N 18050922N64231Driessen James A Jr · Oshkosh, WIBuilt 1982 · S/N 17275538N64232Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1975 · S/N 17265108N64233Walla Walla University · College Place, WABuilt 1975 · S/N 17265109N64235Skyhawk Flying Club · Marysville, OHBuilt 1975 · S/N 17265110N64236Wright Chris E · Houghton Lake, MIBuilt 1975 · S/N 17265111N64238Global Adventures N64238 LLC · Hollywood, FLBuilt 1975 · S/N 17265112N6423BMolina Rodney R · New Kent, VABuilt 1956 · S/N 29623N6423SBores Scott J · Huron, OHBuilt 1968 · S/N 15067223N64240Lazy Eights Holdings LLC · Greenwood, INBuilt 1975 · S/N 17265114N64241Monette Verne G · Anchorage, AKBuilt 1975 · S/N 17265115N64242Goeke Randall D · Alexandria, MNBuilt 1975 · S/N 17265116N64249N64249 LLC · Pottsboro, TXBuilt 1975 · S/N 17265123N6424EBurns Travis Lance · Lake Wales, FLBuilt 1959 · S/N 46524
Back to AD 79-10-14 R1