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.

N9706XEl Paso Aero Inc · El Paso, TXBuilt 1962 · S/N 21058006N97071Heckathorn Chad W Trustee · Elk Point, SDBuilt 1979 · S/N 18266962N97073Rodland Karin D · New Concord, OHBuilt 1979 · S/N 18266963N97075Sopwith Camel Flying Club LLC · Salt Lake City, UTBuilt 1984 · S/N 17276152N97077Trail-Guides LLC · Sharpsburg, GAS/N 18266966N9707GBurns Patrick · Carnation, WABuilt 1971 · S/N 18052207N97082N97082 LLC · Scottsdale, AZS/N 18266971N97084Dockall Jesse A · Litchfield Park, AZBuilt 1979 · S/N 18266972N97087Alpha Bravo LLC · Egan, LAS/N 18266973N9708ABlack Mountains Air LLC · Madison, INS/N 19169N9708BBaxter Christopher V · Anchorage, AKBuilt 1957 · S/N 50006N9708GDma Enterprises LLC · Fort Worth, TXBuilt 1971 · S/N 18052208N97096Lacy Clay · Groveland, CABuilt 1979 · S/N 18266976N97097Youngman David A · Boca Raton, FLBuilt 1979 · S/N 18266977N97099Northwoods Air LLC · Orono, MEBuilt 1979 · S/N 18266978N9709AMckibbon Paul Lee · Millsap, TXBuilt 1949 · S/N 19170N9709BPeterson Air LLC · Chisago City, MNBuilt 1981 · S/N 172RG0982N970CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281970N970LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12040N970MRGlobal Aviation LLC · Grain Valley, MOS/N 21059904N970RBBas Part Sales LLC · Greeley, COS/N 17250175N9710ASky Mobility LLC · Warrington, PABuilt 2006 · S/N 172S10149N9710BWellnitz Patrick · Whitewater, WIS/N 172RG0983N9710FAtp Aircraft 4 LLC · Wilmington, DEBuilt 1997 · S/N 17280017N9710GThompson William G · Mattawa, WABuilt 1971 · S/N 18052210N9710TTrzynka Dean A · Iron River, WIBuilt 1960 · S/N 47510N97116N97116 LLC · Hector, MNS/N 17276155N9711AJones Stanley A · Benkelman, NEBuilt 1969 · S/N 18260098N9711GBurcham Robert A · Anchorage, AKBuilt 1971 · S/N 18052211N9711ZRed Leasing LLC · Juneau, AKBuilt 1982 · S/N U20606619N97123Peak Investments LLC · Roanoke, VABuilt 1979 · S/N 18266984N97127Sandquist Michael A · Molalla, ORBuilt 1979 · S/N 18266985N9712BLafleur Kerry P · Fort Worth, TXBuilt 1957 · S/N 50010N9712GReynolds Frederick A · Pilot Point, AKBuilt 1971 · S/N 18052212N97133Niner 7133 LLC · Layton, UTBuilt 1979 · S/N 18266987N9713ARueckl Randall L · Hortonville, WIBuilt 1950 · S/N 19403N9713FDhs Operations LLC · Wilmington, DEBuilt 1997 · S/N 17280018N9713GKochert Timothy B · Anchorage, AKBuilt 1971 · S/N 18052213N97146Silver City Aviation LLC · Sterling, KSBuilt 1979 · S/N 18266991N97148Cullen Kevin · Bethesda, MDBuilt 1979 · S/N 18266992N9714AReinoehl Gregg A · Reelsville, INBuilt 1949 · S/N 19175N9714XEtheredge William T IV · Texas City, TXBuilt 1962 · S/N 21058014N97154Poddoubnyi Andrey Alexandrovich · Vista, CABuilt 1984 · S/N 17276160N97156Skaglin Michael S · White Lake, MIBuilt 1979 · S/N 18266996N97157Oliver Blake H · Talbotton, GABuilt 1979 · S/N 18266997N97159Quetzal Aviation Corp · Washington, DCBuilt 1979 · S/N 18266999N9715AGarry L Lewis · Livingston, LABuilt 1949 · S/N 19176N9715FPlock Cory J · Southbury, CTBuilt 1997 · S/N 17280030N9715GMonfore Mark A · Wasilla, AKS/N 18052215N97160Foster Mark C Trustee · Carson City, NVBuilt 1979 · S/N 18267000
Back to AD 79-10-14 R1