OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,578

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.

N169DPAdrenaline Inc · Chambersburg, PAS/N 34979N169ECFirst Eclipse Limited · Richmond, VABuilt 1980 · S/N 172RG0515N169FLBlue Moon Holding Co LLC · Boca Raton, FLS/N 17700047N169FTHolmstrom Darrell D Trustee · Anchorage, AKBuilt 1956 · S/N 32389N169HCButterfly Wings Of Miami LLC · Miramar, FLBuilt 1973 · S/N 17262693N169JABixby & Sons LLC · Vale, ORBuilt 1964 · S/N 18256004N169JWPatterson Matthew D · Knoxville, TNBuilt 1968 · S/N 17700360N169KD182 Flight Corp · Bronx, NYBuilt 1979 · S/N 18267456N169LPLcc East LLC · Freehold, NJBuilt 1999 · S/N 172S8234N169MECc Aviation Inc · Tracy, CABuilt 2000 · S/N 172S8449N169NMaxfield Douglas · Chico, CABuilt 1962 · S/N 18051138N169NESouth Coast Aviation Inc · North Bend, ORS/N 17275794N169PGHarty Joshua · Strasburg, COS/N T210-0423N169PPOrtiz Peter · El Paso, TXBuilt 1985 · S/N 18268444N169PXXing Kong Aviation Service LLC · Atwater, CAS/N 17281404N169TFStewart Scott A · Anchorage, AKS/N 185-0383N169WCGlobal Aircraft Trust Inc Trustee · Cheyenne, WYBuilt 1963 · S/N 15060082N16AJA&J Air Sales Inc · San Antonio, TXS/N 28531N16AXKing Austin · Abilene, TXBuilt 1980 · S/N 21064101N16CJRoyale Air Service Inc · Fort Myers, FLS/N U20602501N16DBDivan Richard W · Wautoma, WIBuilt 1969 · S/N 17258618N16EDSimply Living LLC · Fort Myers, FLBuilt 1985 · S/N 172RG1189N16EKCenterline Holdings LLC · Belgrade, MTBuilt 1975 · S/N 17265927N16FHodge Justin Eugene · White Sands, NMBuilt 1956 · S/N 28327N16GBWester Lawrence Cale · Star, IDBuilt 1973 · S/N U20602075N16GHGreysky LLC · Smyrna, TNBuilt 2026 · S/N 172S13519N16GPDeckload Aviation LLC · Kodiak, AKS/N U20604467N16HTAviation Specialties Unlimited Inc · Boise, IDBuilt 1964 · S/N 2060134N16KFFournier Louis W · Fort Worth, TXBuilt 1965 · S/N 15061619N16KNIgwt Holding LLC · Richardson, TXBuilt 1965 · S/N 17253986N16MSEnergy Transfer Aviation LLC · Spring, TXBuilt 1979 · S/N 18267267N16PFTurbine Financial Group LLC · Ogden, UTS/N R1722771N16SBZabel Victor R · Albuquerque, NMBuilt 1956 · S/N 29272N16SHDickinson James C · Haslet, TXBuilt 1972 · S/N 15073404N16VCStallion Leasing LLC · Louisville, KYBuilt 1976 · S/N 17267939N16VVLaughlin R C Jr · Boerne, TXBuilt 1967 · S/N R1720058N16WLLivingston Patricia R · Wasilla, AKS/N 17256545N16ZAVisser Johannes Christoffel · Reno, NVBuilt 1980 · S/N 21063807N170Schaffer Grant B · Springfield, ORBuilt 1952 · S/N 25122N17001Shields David A · Saylorsburg, PAS/N 15073572N17004Depietro Shelley Jo · Olympia, WABuilt 1972 · S/N 15073575N17009Wight John I · Anchorage, AKBuilt 1972 · S/N 15073578N1700CKrause Kade G · Jackson, MTBuilt 1953 · S/N 30400N1700DJohnson Robert Kenneth · Monte Rio, CABuilt 1951 · S/N 20143N1700MDeltahawk Engines Inc · Racine, WIBuilt 1970 · S/N 33701300N1700QAtkinson Jonathan E · Chapmansboro, TNBuilt 1971 · S/N 15073000N1701Rolston Charles W · Shoreview, MNBuilt 1964 · S/N 17252418N17011Saunders Aviation LLC · South Portland, MEBuilt 2007 · S/N 18282010N17014Alcorn Paul W · Bay City, MIS/N 15073581N17016Mika Brian D · Andover, MNBuilt 1972 · S/N 15073583
Back to AD 79-10-14 R1