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.

N9598HImsar LLC · Springville, UTBuilt 1975 · S/N 17266256N9598XOdell Eugene S · Yakima, WABuilt 1962 · S/N 21057898N9599ABaldwin Trevor K · Owasso, OKBuilt 1949 · S/N 19160N9599TAviation Partners LLC · Highlands Ranch, COBuilt 1960 · S/N 57399N959AGGrant Altin C · Tahlequah, OKBuilt 1973 · S/N 17701952N959CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281969N959HCNorthwest Wings LLC · Hillsboro, ORBuilt 1973 · S/N 17262361N959JATriple Eagle Aviation LLC · Cambridge, VTBuilt 2007 · S/N 172S10510N959RMLargent Richard B · Southport, NCBuilt 1970 · S/N 17259113N959UAUniversity Of Alaska Anchorage · Anchorage, AKBuilt 2007 · S/N 172S10526N959YBoard Of Trustees Of Southern Illinois University · Carbondale, ILBuilt 2023 · S/N 172S12959N95AFNeville William J III · Marianna, FLBuilt 1971 · S/N 177RG0126N95AMWilkes Flying Service Inc · Simmesport, LABuilt 1957 · S/N 32891N95BPPeraton Services LLC · Bozeman, MTBuilt 2012 · S/N 172S11108N95BWAgwerx Aviation Inc · Mapleton, IABuilt 1976 · S/N 18052727N95CPGates Thomas S · Moyock, NCBuilt 1976 · S/N 17265896N95DMValley Gabriel P · Holden, MES/N 18504319N95EAFray Jonathan C · Wasilla, AKS/N 18052052N95EMHoeft Gregory D · Glennallen, AKBuilt 1963 · S/N 18051306N95FCDerscos LLC · Colorado Springs, COBuilt 1975 · S/N 18263694N95GCGrant James T · Huntsville, ALBuilt 1960 · S/N 47386N95GRSim International Inc · Fort Mill, SCBuilt 1978 · S/N 18266666N95GSStephen George A · Anna Maria, FLBuilt 1979 · S/N 18267146N95JALane Christopher C · Dallas, TXBuilt 1979 · S/N 172RG0015N95JRKaiser Dennis · Portland, MEBuilt 1980 · S/N 18504074N95LHubbert Stephen A · Newcastle, OKS/N 15383N95MBNobbe Leon W · Greensburg, INBuilt 1977 · S/N 18265872N95MRH&M Air LLC · Georgetown, TXBuilt 1973 · S/N 18261797N95PFEhorn William M · Cottonwood, CAS/N 18265281N95PYJayviation Inc · Lake City, FLBuilt 1964 · S/N 21058514N95REMcquown Todd J · Montgomery, TXBuilt 1955 · S/N 31835N95TFSage Mgmt LLC · Carefree, AZBuilt 1981 · S/N U20606137N9600ABooth Donald V · Denison, TXBuilt 1949 · S/N 15321N96019Bunde Conley R · Anchorage, AKBuilt 1960 · S/N 50901N9601QSteel Aviation Inc · Walnut Cove, NCBuilt 1975 · S/N 17265686N9601XCervantes Jose M · San Diego, CAS/N 21057901N96024Strite Jaylon · Cochise, AZS/N R172-0148N9602AGutkowski Robert L · Arlington, TXBuilt 1949 · S/N 15323N9602BLaguna Verde Leasing Inc · Wilmington, DES/N 172RG0912N9602HC & J Flight Co LLC · Sardis, MSBuilt 1981 · S/N 18267969N9602XMorehouse Darrell L · Glasgow, MTBuilt 1962 · S/N 21057902N9603QConnecticut Flyers Inc · Madison, CTBuilt 1975 · S/N 17265688N9603XTerry Nickolas B · Maize, KSBuilt 1962 · S/N 21057903N96047Ohio Car Wash Supply LLC · Lancaster, OHS/N 18264485N9604GRoberts Development Company Inc · Tucson, AZBuilt 1972 · S/N U20601804N9604TKay Bennie L · Brigham City, UTBuilt 1961 · S/N 57404N96051Franklin Evelyn Ruth Trustee · Laveen, AZS/N 18264408N9605ADavis Rickard J · Los Lunas, NMBuilt 1949 · S/N 15326N9605QBragan Ryan J · Dunedin, FLBuilt 1975 · S/N 17265690N9605XTony Flies Inc · Sparta, NCBuilt 1962 · S/N 21057905
Back to AD 79-10-14 R1