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.

N681DCDoodle Air LLC · San Jose, CABuilt 2016 · S/N 172S11681N681DWSunrise Aviation Inc · Ormond Beach, FLBuilt 2000 · S/N 17280942N681EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2026 · S/N 172S13572N681MAChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 172S8203N681RLWeatherby Thomas M · Rcho Sta Marg, CAS/N 28633N6820GJensen Eric Gunnar · Ogden Dunes, INBuilt 1970 · S/N 15072320N6821AArmiger Scott Linwood · Holly Springs, NCBuilt 1956 · S/N 28921N6821EPriest Justin E · Arlington, WABuilt 1959 · S/N 56321N6821GMueller Carla I · Lexington, SCS/N 15072321N6821XTudorani Vincenzo C · Las Vegas, NVS/N 47721N6822AStewart Brock Allen · Bartlett, TNBuilt 1956 · S/N 28922N6822GKnot Enough Airspeed LLC · Oshkosh, WIBuilt 1970 · S/N 15072322N6822MSunnysideup LLC · Las Vegas, NVBuilt 1975 · S/N 18263849N6823AWilliams Daniel H · Fort Mcdowell, AZBuilt 1956 · S/N 28923N6823HClay Howard C II · San Francisco, CAS/N 17265596N6823XTipton Wendell D · Anchorage, AKBuilt 1960 · S/N 47723N6824AChristenson Robert E · Anacortes, WABuilt 1956 · S/N 28924N6824RSquadron 5 Inc · Saratoga, CABuilt 1966 · S/N T210-0224N6825ABarker Jason · Hampton Falls, NHBuilt 1956 · S/N 28925N6825FKieffer Jason M · Omaha, NEBuilt 1966 · S/N 15063425N6825GRhodes Bruce A · Santa Cruz, CABuilt 1970 · S/N 15072325N6826BDan Howard Aircraft Sales LLC · Tulsa, OKBuilt 1978 · S/N 21062840N6826ERudolphi Ben M · Valdosta, GAS/N 56326N6826FJeppesen Thomas L · Stanton, MIBuilt 1966 · S/N 15063426N6826GStar Voyages LLC · Kissimmee, FLS/N 15072326N6827GBrooks Jeffrey C · Bridgeton, NJBuilt 1970 · S/N 15072327N6827XCalderon Daniel C · Castro Valley, CABuilt 1960 · S/N 47727N6828ESheppard Walter S · Troy, IDBuilt 1959 · S/N 56328N6829ABaker Elbert W · Beckley, WVBuilt 1956 · S/N 28929N6829ELay Steven K · New Vienna, OHBuilt 1959 · S/N 56329N6829XZeegers Jozef · Bellingham, WABuilt 1960 · S/N 47729N682ADDuncan Brian · Indianapolis, INBuilt 1971 · S/N 15072493N682ASRegistration Pending · Stony Brook, NYRegistration pendingBuilt 1997 · S/N 18280007N682CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11539N682DWMach X Aviation LLC · Weston, FLBuilt 2000 · S/N 17280943N682MAChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 172S8204N682PBoard Of Trustees Of Southern Illinois University · Carbondale, ILBuilt 2023 · S/N 172S12963N682SBSundowners Inc · Fort Myers, FLBuilt 2003 · S/N 18281218N682SPHansell Stephen E · East Windsor, NJBuilt 2008 · S/N 18282090N6830ALange Cole K · Oglala, SDBuilt 1956 · S/N 28930N6830EJackson Thomas M · Florissant, MOBuilt 1960 · S/N 56330N6830MJ & J Air LLC · Laurel, MSBuilt 1975 · S/N 18263850N6830RElizalde Carla Zankiz · Estero, FLBuilt 1967 · S/N T210-0230N6831ASale Reported · Pullman, WASale reportedS/N 28931N6831HQuarry Jon C · Memphis, TNBuilt 1975 · S/N 17265600N6831MSouth Beach Adventure Sports LLC · Bald Head Island, NCBuilt 1977 · S/N 21061994N6832EStuebner David M · Delanson, NYBuilt 1959 · S/N 56332N6832GAeronautical Technical Service Inc · Collierville, TNS/N 15072332N6832RWheeler David G Jr · Chico, CAS/N T210-0232N6832XOwens Philip A · Maryville, TNBuilt 1960 · S/N 47732
Back to AD 79-10-14 R1