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.

N493RMRaritan Valley Flying School · Princeton, NJBuilt 1999 · S/N 17280784N493SHForsman David G Co-Trustee · South Haven, MNBuilt 1968 · S/N 17256881N493WCOsness Rhonda R · Bisbee, NDBuilt 1973 · S/N P3370090N4940ASims Charles A · Chugiak, AKBuilt 1956 · S/N 32337N4940DAirborne One LLC · Kalispell, MTS/N 51040N4940EFlyright Aviation Inc · North Las Vegas, NVBuilt 1978 · S/N 17271681N4940GN4940g LLC · Portsmouth, NHS/N 17273487N4940NWray James R Jr · Brighton, COBuilt 1979 · S/N 18267465N4941FPaddock Levi · Springfield, ORS/N U206-0641N4942AChapman Peter E · Placerville, CABuilt 1956 · S/N 32339N4942DN4942d LLC · Greenfield, NHBuilt 1958 · S/N 51042N4942UCenturion LLC · Bonney Lake, WABuilt 1965 · S/N 21058642N4943EPettit Robert · Carnegie, OKS/N 18503914N4944DSelkirk Associates Inc · Wilmington, DEBuilt 1958 · S/N 51044N4944PReed John Richard · Charleston, ILBuilt 1964 · S/N 18255703N4944RRoma Air Corp · Belle Glade, FLBuilt 1975 · S/N 18802461TN4945AIverson Randy · Winnemucca, NVBuilt 1956 · S/N 32342N4946ESallmon Helga R · Sandpoint, IDFirst renewal noticeBuilt 1979 · S/N 18503916N4947AGleiter David W · Overland Park, KSBuilt 1956 · S/N 32344N4947DEnstrom Thomas · New Berlin, NYBuilt 1958 · S/N 51047N4947GRiya Aviation LLC · Tracy, CABuilt 1980 · S/N 17273494N4947QDavison Aviation LLC · Garnett, KSBuilt 1976 · S/N 18802682TN4948CRobillard Ross · Eveleth, MNBuilt 1975 · S/N 18502664N4948DSobrado Victor M · Norman, OKBuilt 1958 · S/N 51048N4948GTrece Inc · Adair, OKS/N 17273495N4948QWhite Ronald A · Anchorage, AKBuilt 1978 · S/N 18503583N4948RBlain Monte W · Joliet, MTBuilt 1975 · S/N 18802465N4948URegistered aircraftBuilt 1965 · S/N 21058648N4949ETrans Crafts LLC · Big Lake, AKBuilt 1979 · S/N 18503917N4949GFalcon Aviation LLC · South Saint Paul, MNBuilt 1979 · S/N 17273496N4949NCompass Rose Aviation · Derby, KSBuilt 1979 · S/N 18267474N4949RValley Flying Service Inc · Orleans, NEBuilt 1975 · S/N 18802466TN494AMOsprey Holding Company LLC · Foley, ALBuilt 1978 · S/N 17269969N494EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2015 · S/N 172S11602N494JBD & S Aviation LLC · Spring, TXBuilt 2002 · S/N 172S9099N494PCChristensen Darrel W Jr · Soldotna, AKS/N U20603156N494RAAstra Integrated Technologies LLC · Rockledge, FLBuilt 1967 · S/N 15066996N494SPInternational Air Services Inc Trustee · Carson City, NVBuilt 1998 · S/N 172S8035N494TMDuke Flight Training LLC · Bonnyman, KYBuilt 1975 · S/N 17265022N494WAFly More Inc · Kawkawlin, MIBuilt 1978 · S/N 17271129N4950DSimpson Darrell W · Soldotna, AKBuilt 1979 · S/N 17272408N4950HVaivadas Brian S · Bonney Lake, WABuilt 1981 · S/N 18267856N4950RCivil Air Patrol Inc Natl Hdqtrs · Maxwell Afb, ALBuilt 1984 · S/N U20606810N4950UAerotech Mapping Inc · Las Vegas, NVBuilt 1979 · S/N U20605174N4950ZRiverside Tractor Inc · Friendswood, TXBuilt 1980 · S/N U20606055N4951FAerial Services Inc · Cedar Falls, IAS/N U206-0651N4951GMelbourne Flight Training LLC · Melbourne, FLBuilt 1979 · S/N 17273498N4951NCactus Av8rs LLC · Gilbert, AZBuilt 1979 · S/N 18267476N4951YH & B Aeronautics LLC · Miamisburg, OHBuilt 1980 · S/N 21064057N4952EHess Michael D · Wasilla, AKBuilt 1979 · S/N 18503918
Back to AD 79-10-14 R1