OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,580

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.

N2790DRegistered aircraftBuilt 1952 · S/N 25332N2790GBryan Roger J · Spearfish, SDBuilt 1959 · S/N 52090N2790JLock Robert Allen · Grand Haven, MIBuilt 1975 · S/N A1500602N2790LWells Mark L · Eads, TNBuilt 1967 · S/N 17255990N2790QArthur Lloyd T · Greenfield, INS/N 18257990N2791GHoutte Edmund Michael DBA · Palmer, AKBuilt 1959 · S/N 52091N2791JPuget Sound Flyers Inc · Everett, WABuilt 1975 · S/N A1500603N2792CBerg Timothy J · Fairbanks, AKBuilt 1954 · S/N 26336N2792FRoshong Loman · Leesville, LABuilt 1966 · S/N 18256892N2792GSpeedstar Aviation LLC · Kalispell, MTBuilt 1959 · S/N 52092N2792JAndresen Leonard W · Anchorage, AKBuilt 1969 · S/N 185-1542N2792QPalmer Paul F · Donnelly, IDBuilt 1967 · S/N 18257992N2793GMeyer Steven D · Snohomish, WABuilt 1959 · S/N 52093N2794DBrown Rayford K · Temple, TXBuilt 1952 · S/N 25336N2794GClark Jeremiah Jacob · Pleasant Plains, ARBuilt 1959 · S/N 52094N2794JRegistration Pending · Anchorage, AKRegistration pendingBuilt 1969 · S/N 185-1546N2794QVincer Way LLC · Centennial, COBuilt 1967 · S/N 18257994N2795CCales Jack R · Edisto, SCBuilt 1954 · S/N 26339N2795FRegistration Pending · Marietta, GARegistration pendingBuilt 1966 · S/N 18256895N2795JEndeavour Flight Training Inc · Miami, FLBuilt 1979 · S/N 17273650N2795LHarkness Paul E · Richmond Hill, GABuilt 1967 · S/N 17255995N2795URichardson Robert S · Austin, TXBuilt 1963 · S/N 17250395N2796DFrance Gregory G · Alta Loma, CABuilt 1952 · S/N 25338N2796FX-Ray Engineering Corp · Port Orange, FLS/N 18256896N2796GDouglas Cattle LLC · Douglas, AZBuilt 1959 · S/N 52096N2796LSmyth Michael L · Saint Charles, MOBuilt 1967 · S/N 17255996N2797DEberhart Wayne Willis · Amboy, MNBuilt 1952 · S/N 25339N2797EPalm Beach Flyers LLC · Boca Raton, FLS/N 17271324N2797FWhatley Charles J · Goliad, TXBuilt 1965 · S/N 18256897N2797JAlaska Ultimate Safaris LLC · Homer, AKBuilt 1969 · S/N 185-1555N2798EPumpkin Eater LLC · Tavares, FLBuilt 1978 · S/N 17271325N2798FGoodall Maurice M II · Omak, WABuilt 1966 · S/N 18256898N2798GBremerton City Flying Club · Poulsbo, WABuilt 1959 · S/N 52098N2798JCenter Of Gravity Flying Club LLC · Monterey, CABuilt 1975 · S/N A1500607N2798XElsner Kelly John · Menahga, MNBuilt 1965 · S/N 18051598N2799CTaylor James L · Lowell, ARBuilt 1954 · S/N 26343N2799GMartin Aviation LLC · Scottsboro, ALS/N 52099N2799QZerden David F · Lincoln Park, NJBuilt 1972 · S/N 18261592N2799UWinslow Linda S Trustee · Creswell, ORS/N 17250399N2799XHess James R · Heathsville, VABuilt 1965 · S/N 18051599N279CMMckenzie Robert A · Downers Grove, ILBuilt 1969 · S/N 18259822N279JSAnnapolis Aviation LLC · Annapolis, MDBuilt 1978 · S/N 18266499N279MCMagic Carpet LLC · Wilmington, DEBuilt 1954 · S/N 26331N279MEBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 172S8535N279RWPoe James K · Walterboro, SCBuilt 1959 · S/N 52347N27AHM W T Aviation LLC · Jamestown, NYBuilt 1975 · S/N 17265306N27AKLingle Bryan K Sr · Bradenton, FLBuilt 1979 · S/N 18266826N27BSl Leasing Group LLC · Barnesville, GABuilt 1975 · S/N 21061108N27BLFairmont State University · Fairmont, WVBuilt 2020 · S/N 172S12467N27CSFeauto Aviation Inc · Saint Cloud, FLBuilt 1964 · S/N 17251680
Back to AD 79-10-14 R1