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.

N7485APrecup Michael P Sr Trustee · Perrysville, OHBuilt 1956 · S/N 29585N7485CYanover Joseph J · Traverse City, MIBuilt 1974 · S/N 18502373N7485EJacques Steve C · Centennial, COBuilt 1960 · S/N 57185N7485GIndependent Aviation Services LLC · Sachse, TXBuilt 1970 · S/N 17259185N7485MLyons Adrian K · Torrance, CABuilt 1959 · S/N 55785N7485QEvans Charles H Trustee · Hooksett, NHBuilt 1973 · S/N U20602220N7485XEngland Robert C · Zanesville, OHBuilt 1960 · S/N 17247985N7486MYaeger John F · Au Gres, MIBuilt 1959 · S/N 55786N7486SGarage Doors Of Greenville LLC · Greenville, MSBuilt 1969 · S/N 15070358N7486TRhodes Vergil H Jr · Bartlesville, OKBuilt 1959 · S/N 47086N7487ANelson Rodney G · Amenia, NDBuilt 1957 · S/N 29587N7487GRich Aviation Services LLC · Fort Worth, TXBuilt 1970 · S/N 17259187N7487MMaple Lake Flyers Corp · Maple Lake, MNBuilt 1959 · S/N 55787N7487Q206 LLC · Anchorage, AKBuilt 1973 · S/N U20602221N74887Mroz Kaitlin J · Haslet, TXBuilt 1953 · S/N 25853N7488MFegert Jeff · Las Vegas, NVBuilt 1959 · S/N 55788N7489AAllianna LLC · Fayetteville, ARBuilt 1956 · S/N 29589N7489GCloud Fleet Aviation LLC · Fort Lauderdale, FLBuilt 1970 · S/N 17259189N7489MMerinar John R Jr · Bridgeport, WVBuilt 1959 · S/N 55789N7489QLlano Masonry LLC · Lubbock, TXBuilt 1972 · S/N 18261129N748CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11570N748KPKalinin Partners LLC · Juneau, AKBuilt 1976 · S/N U20603279N748MKAero-Tech Services Inc · Lititz, PABuilt 2022 · S/N 172S12780N748SPBg-Ip LLC · Saratoga, CABuilt 2000 · S/N 172S8682N748WPParker Charles W III · Anchorage, AKBuilt 1967 · S/N 185-1207N748XMorgan Bryon E · Eugene, ORS/N 3370029N749United States Department Of Interior · Boise, IDBuilt 1982 · S/N 18504354N7490XDawson Ejay J · Eveleth, MNBuilt 1960 · S/N 17247990N7491AMckee Paul R · Astoria, ORBuilt 1957 · S/N 29591N7491EBenscoter Richard S · Nordman, IDBuilt 1960 · S/N 57191N7491GAccess Air Service Inc · Mercedita, PRBuilt 1970 · S/N 17259191N7492TSale Reported · Newport, ORSale reportedS/N 47092N7493GHaugo Robert P · Scobey, MTBuilt 1970 · S/N 17259193N7493TLee Cody C · Denton, MTS/N 47093N7495MPlumley David E · Waxhaw, NCBuilt 1959 · S/N 55795N7495XIsch Philip D · Geneva, INBuilt 1960 · S/N 17247995N7496AMcreynolds Sean D · Visalia, CABuilt 1956 · S/N 29596N7496MMcmurray Patrick T · Brush Prairie, WABuilt 1959 · S/N 55796N7496XAbove All Aviation Inc · Santa Barbara, CABuilt 1960 · S/N 17247996N7497AJohnson Kurt W · Jordan, MNBuilt 1956 · S/N 29597N7497EDunford David R · Maryville, TNBuilt 1960 · S/N 57197N7497TLeffler Greg L · Zion Crossroads, VABuilt 1959 · S/N 47097N7497XTrinciante Fernando S · Thief River Falls, MNBuilt 1960 · S/N 17247997N7498ATorrey Robert S · Anchorage, AKBuilt 1957 · S/N 29598N7498TLala Princy · Deltona, FLBuilt 1959 · S/N 47098N7499ADurousseau Joseph Harry Trustee · Sparks, NVBuilt 1957 · S/N 29599N7499CHillsboro Flying Club · Hillsboro, ORBuilt 1981 · S/N 17274992N7499TWright Donald E · Greensboro, NCBuilt 1959 · S/N 47099N7499XVintage Aircraft Ltd · Hortonville, WIBuilt 1960 · S/N 17247999N749KPKalinin Partners LLC · Juneau, AKBuilt 1980 · S/N U20605554
Back to AD 79-10-14 R1