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.

N6164TRubin Andrew C · Rochester, NHBuilt 1964 · S/N 15060864N61651Clw Aviation LLC · Springville, ALBuilt 1975 · S/N 17264702N61653Michel Daniel T · Sterling, AKBuilt 1976 · S/N 18052786N61655Air Planes LLC · Soddy Daisy, TNBuilt 1975 · S/N 17264704N61656Dismang Chad C · Boynton, OKS/N 17264705N61657Bell Ornithopters Flying Club Inc · Eastlake, COBuilt 1975 · S/N 17264706N61658Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1975 · S/N 17264707N61659Bowerman Richard E · Wetmore, MIBuilt 1975 · S/N 17264708N6165EBailey Frank W · White City, ORBuilt 1958 · S/N 46265N6165FMainely Lobsters · Gulf Breeze, FLBuilt 1968 · S/N 21059065N6165GPartida Carlos · Delray Beach, FLBuilt 1969 · S/N 15071665N61662Huston Stephen M · Hollister, CABuilt 1976 · S/N 18052787N61663Mohamed Eman Z · Lubbock, TXBuilt 1975 · S/N 17264712N6166EAshabranner Kevin T · Port Saint Joe, FLBuilt 1958 · S/N 46266N6166NBrian C Haggerty LLC · Pembroke Pines, FLBuilt 1981 · S/N 18504302N6166UBb Aviation LLC · Prescott, AZBuilt 1979 · S/N U20605359N61670Registered aircraftBuilt 1975 · S/N 17264717N61671Charlotte Flyers Inc · Fort Myers, FLBuilt 1975 · S/N 17264718N61672American Patrols Inc · Midland, TXBuilt 1975 · S/N 17264719N61676Vectors LLC · Sterling, VABuilt 1975 · S/N 17264721N61677Morcom Aviation Services Inc DBA · Everett, WABuilt 1975 · S/N 17264722N6167BEdwards Darrell R · Artesia, NMBuilt 1957 · S/N 34167N6167CSnyder Larry G · Holland, NYBuilt 1979 · S/N 21063818N6167EMiller James C III · Papillion, NES/N 15059791N6167FJohnson Susan J · Chelan, WABuilt 1973 · S/N A1500437N6167KDuncan Marianna G · Lufkin, TXBuilt 2004 · S/N 18281379N6167LEastern Cincinnati Aviation Inc · Batavia, OHBuilt 2004 · S/N 18281380N6167NMillhorn Farms Inc · Worley, IDS/N 18504303N6167TBurton William F · Shiloh, NJBuilt 1964 · S/N 15060867N61680Kaye Linda · Grove, OKBuilt 1975 · S/N 17264724N61683Migdalski Randall C · Pembroke Pines, FLBuilt 1975 · S/N 17264727N61684Odyssey Aircraft LLC · Topeka, KSBuilt 1975 · S/N 17264728N61687Advanced Rehab Specialties Pa · Leesburg, FLS/N 17264731N61689Bc 414 LLC · Los Angeles, CABuilt 1975 · S/N 17264732N6168BSafety Source LLC · Kirkland, WAS/N 34168N6168EFoster Marcus R · Mesa, AZBuilt 1958 · S/N 46268N6168NRegistered aircraftBuilt 1978 · S/N 21062939N61692Pittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1975 · S/N 17264734N61696Bakker Margaret E Trustee · Petaluma, CABuilt 1975 · S/N 17264737N61697L&W Aircraft Investment LLC · Homestead, FLBuilt 1975 · S/N 17264738N61699Erickson Steve · St Michael, MNBuilt 1975 · S/N 17264740N6169BTjs Plane LLC · Renton, WABuilt 1957 · S/N 34169N6169EVick Troy · Normangee, TXS/N 46269N6169FWatrud Joel Carl · Waskish, MNS/N 21059069N6169GKingdom Air Corps · Sutton, AKBuilt 1969 · S/N 15071669N6169RN999gk LLC · Nantucket, MAS/N 172RG0102N6169TZelner Gregory · Merritt Island, FLBuilt 1964 · S/N 15060869N616AADowns Kenneth · Houston, TXBuilt 1975 · S/N 17265524N616CPTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 18283352N616FKenzy 2020 LLC · Aurora, ORBuilt 2020 · S/N 172S12516
Back to AD 79-10-14 R1