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.

N5323URio Farms LLC · King City, CABuilt 1984 · S/N 21064865N53243Fly Low Aviation LLC · Ashley, NDBuilt 1974 · S/N 18801706TN53245Kirk Ben C · Louisville, MSBuilt 1974 · S/N 18801708TN5324GFloris Flight Services LLC · Midland, TXBuilt 2003 · S/N 172S9315N5324VAviation Resources LLC · Post Falls, IDBuilt 1977 · S/N R1722288N5325BHinman Joshua D · Arcadia, CABuilt 1956 · S/N 33325N5325NSchindler Lawrence A · Chino Valley, AZBuilt 2003 · S/N 172S9317N5325QIlm Aviation LLC · Waxahachie, TXBuilt 1972 · S/N 15073225N5325RBardo Daniel J · Salem, OHBuilt 1965 · S/N 17252850N5325SR & H Aviation LLC · Shady Shores, TXBuilt 1966 · S/N 337-0425N5325YBeehive Telephone Co Inc Nevada · Lake Point, UTBuilt 1980 · S/N 21064164N53262Fort Leavenworth Flying Activity · Fort Leavenworth, KSBuilt 1981 · S/N 17274713N53265Jeppesen Employees Flying Association · Englewood, COBuilt 1981 · S/N 17274714N5326BBoatman Charles L · La Porte, TXBuilt 1956 · S/N 33326N5326DHiebert Nathan D · Newton, KSS/N 50224N5326KCornelius Aviation Inc · Mooresville, NCBuilt 1980 · S/N 17274066N53277Petecraft Aviation Services Inc · Plains, GABuilt 1974 · S/N 18801732TN5327DPiekarski John S · Wichita Falls, TXBuilt 1958 · S/N 50225N5327GDirty Side Down Aviation LLC · Georgetown, TXS/N 172S9357N5327JEdb Air Inc · Wilsonville, ORBuilt 2003 · S/N 172S9356N5327QLarsen Deziree L · Bay Point, CABuilt 1972 · S/N 15073227N5327RMcgrath John J · Littleton, COBuilt 1965 · S/N 17252852N5327SLowry Steve H · Sun River, MTBuilt 1966 · S/N 337-0427N5327TMurphy Shane T · Bird Creek, AKBuilt 1964 · S/N 17251227N5327VSouthern Illinois University · Murphysboro, ILBuilt 2003 · S/N 17281151N53289Christiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9331N5328BUninsured Swope 182 LLC · Kalispell, MTBuilt 1956 · S/N 33328N5328CLewis George F Jr · Hampton, CTBuilt 1950 · S/N 15448N5328KAvanna LLC · Shaw Island, WABuilt 1980 · S/N 17274067N5328TDiem James L · Kiel, WIBuilt 1964 · S/N 17251228N5328YGa Holdings LLC · Moffett Field, CAS/N 172S9270N5328ZBartow Municipal Airport Development Authority · Bartow, FLBuilt 2003 · S/N 172S9327N53293Tito Hector · Fayetteville, GABuilt 1981 · S/N 17274716N5329CVetterli Gary R · Monroe, WIBuilt 1950 · S/N 15449N5329DMeketa Ann M · La Vernia, TXBuilt 1958 · S/N 50227N5329RDearborn Flying Club Inc · Grosse Pt Shr, MIBuilt 1965 · S/N 17252855N5329SAlabama Forestry Commission · Montgomery, ALBuilt 2003 · S/N 18281198N5329TShort Kenneth L · Setauket, NYBuilt 1964 · S/N 17251229N532DCDc Aviation LLC · Panama City, FLS/N 18265796N532EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2024 · S/N 172S13159N532HFJet Air Inc · Iowa City, IABuilt 2000 · S/N 17280836N532NDAia Bravo LLC · Henderson, NVBuilt 2011 · S/N 172S11102N5330EKrieger Andy G · Katy, TXBuilt 1983 · S/N 18268311N5330NMarion Michael · Canyon Country, CABuilt 1980 · S/N 18267649N5330QBend Aircraft Mechanics LLC · Bend, ORBuilt 1972 · S/N 15073230N5330TMilne Sales And Services LLC · Lake Geneva, WIBuilt 1964 · S/N 17251230N5330UBoard Of Trustees Of Southern Illinois University · Murphysboro, ILFirst renewal noticeBuilt 2003 · S/N 17281152N53310Lucente Michael A · Fort Myers, FLBuilt 2003 · S/N 18281199N53315Denton Aerial Spraying · Las Animas, COBuilt 1975 · S/N 18802213TN53319Souther Field Aviation Inc · Americus, GAFirst renewal noticeS/N 18801758T
Back to AD 79-10-14 R1