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.

N79529Elliott Tina L · Tucson, AZBuilt 1969 · S/N 17258154N7952BEmaw Properties LLC · Ketchum, OKBuilt 1957 · S/N 29752N7952FKagey Ryan D · Seabrook, TXBuilt 1966 · S/N 15064052N7952GPlunkett Charles K E · Eagle Point, ORS/N 15074743N7952TGregg John I Jr · Glendale, AZBuilt 1960 · S/N 56652N7952UTigger II Airways LLC · Towson, MDBuilt 1964 · S/N 17251952N79531Newberry Tyler D · Clovis, CABuilt 1969 · S/N 17258155N79533Eby William J · Sugar Grove, ILBuilt 1969 · S/N 17258156N7953BSavener Eric D · Kingsland, TXBuilt 1957 · S/N 29753N7953GSnyder Kenneth C · Lonsdale, MNBuilt 1973 · S/N 15074744N7953VRegistered aircraftBuilt 1967 · S/N 18051853N7953ZMartin Aviation LLC · Bargersville, INBuilt 1963 · S/N 15060053N79540Funk Kathryn A · Rockledge, FLBuilt 1969 · S/N 17258160N79543Registration Pending · Manns Harbor, NCRegistration pendingBuilt 1969 · S/N 17258163N79546Diakonis Emmanuel W · Maumee, OHBuilt 1969 · S/N 17258165N79549Triad Aviation Academy LLC · Greensboro, NCBuilt 1969 · S/N 17258168N7954FVikingland Flying Club · Alexandria, MNS/N 15064054N7954GNo Squawks LLC · Newcastle, CABuilt 1970 · S/N 17259654N79554Williams Kenneth J · Wasilla, AKBuilt 1969 · S/N 17258171N79558Silver Creek Aviation Services LLC · Snowflake, AZBuilt 1969 · S/N 17258173N7955BCochrane Geoffrey G · Seville, OHBuilt 1957 · S/N 29755N7955FN7955f LLC · Titusville, FLS/N 15064055N7955VHancock Glenn · Jackson, GABuilt 1967 · S/N 18051855N79562Brown Glynna J · Middlesboro, KYBuilt 1969 · S/N 17258176N79565Vm Aero LLC · Camden, DEBuilt 1969 · S/N 17258179N79566Eisele Elton · Schaumburg, ILBuilt 1969 · S/N 17258180N79567Miller Aviation Group LLC · Coon Rapids, MNBuilt 1969 · S/N 17258181N7956FFios Flightline LLC · Tucson, AZBuilt 1966 · S/N 15064056N7956USweeney Daniel N · Radcliff, KYBuilt 1964 · S/N 17251956N7956XNesbit Stephen M · Chino Hills, CABuilt 1961 · S/N 17248456N79571Myers James W · Westmoreland, NHS/N 17258185N79575Fox Valley Flyers Inc · Appleton, WIBuilt 1969 · S/N 17258188N79576Dillon Monte Lane Trustee · Mooresville, INBuilt 1969 · S/N 17258189N79578Dannebrock Paul W · Lockport, NYBuilt 1969 · S/N 17258190N79579Brown Larry · Mesa, AZS/N 17258191N7957ELynn Kerry E · Stow, MABuilt 1960 · S/N 17757N7957GFlying L Aircraft Inc · Fort Denaud, FLBuilt 1970 · S/N 17259657N7957XRoderick Ashley T Jr · Hixton, WIBuilt 1961 · S/N 17248457N79580Bowers James H Jr · Broadus, MTBuilt 1969 · S/N 17258192N79584Ocean Breeze Aviation Inc · Wilton Manors, FLBuilt 1969 · S/N 17258195N79585Valley Forge Aviators LLC · King Of Prussia, PABuilt 1973 · S/N 18261836N79586Booth James L · Fort Collins, COBuilt 1973 · S/N 18261837N79587Twj Aviation 2 LLC · Jacksonville, FLBuilt 1969 · S/N 17258198N79589Aqua Irrigation Technologies LLC · Parma, IDBuilt 1973 · S/N 18261838N7958BThrustline Aviation LLC · Happy Valley, ORS/N 29758N7958VColbern Matthew · Anchorage, AKBuilt 1967 · S/N 18051858N79590Corrigan Michael D · Hondo, TXBuilt 1973 · S/N 18261839N79598Keck Shawn M · Santa Cruz, CAS/N 18261840N79599Hull Aviation Inc · Decatur, ALBuilt 1969 · S/N 17258206N7959BLaminack Dale Wayne · Ralls, TXS/N 29759
Back to AD 79-10-14 R1