AD 75-04-12

Registered aircraft · 402

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:75-04-12')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-04-12')
  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.

N159AFMorter Roger P · Hermiston, ORBuilt 2000 · S/N 413-2000N15MMMeyers David L · Palmer, AKBuilt 2016 · S/N 573-2015N160BCPridmore Reginald C · Laughlin, NVS/N 457-2004N162BCRegistration Pending · Tampa, FLRegistration pendingBuilt 2004 · S/N 465-2004N165ACBrian & Karen Snodgrass Farms LLC · Seminole, TXS/N 471-2005N165BCMckinney William C · Whitefish, MTBuilt 2019 · S/N 600-2019N167BWMartin Jennifer · Palm Desert, CABuilt 1974 · S/N 12475N168BCWildlife Air LLC · Dubois, WYBuilt 2006 · S/N 482-2006N178BCAllen Lisa M · Melba, IDBuilt 2005 · S/N 474-2005N178TTLockwood Kurt G · Fairbanks, AKBuilt 1978 · S/N 278-78N179BCDenmark Ag · Winters, CAS/N 458-2004N180CGBailey Bendrix · Rochester, MABuilt 2002 · S/N 434-2002N180LARonsman Harry M · Talkeetna, AKBuilt 1994 · S/N 368-94N181TMEichhorn Scott William · Searcy, ARS/N 114-74N186ACHartman James R Trustee · Everett, WABuilt 1994 · S/N 369-94N188BCWaldron Elijah L · Murfreesboro, TNBuilt 2019 · S/N 598-2019N188RSVardaman Charles · Little Rock, ARBuilt 1979 · S/N 341-80N189BCEph LLC · Eagle, IDS/N 470-2005N193ACStearman Aviation Inc · Crawford, COBuilt 1993 · S/N 365-93N193GFFlattum Steven · Hampshire, ILBuilt 2006 · S/N 477-2006N194BCAircraft Investments LLC · Ketchum, IDBuilt 2006 · S/N 489-2006N196THHiers Timothy F · Barney, GAS/N 558-2013N197BCSeruset Jeffrey G · Butler, PABuilt 2004 · S/N 461-2004N198BCOconnell Tiffany LLC · Newbury, NHS/N 488-2006N198QQuale Scott · New Town, NDBuilt 2023 · S/N 637-2023N19CKBuckmeier Arlan M · Fairbanks, AKBuilt 1978 · S/N 28078N19CWRussmann Nick S · Merit, TXBuilt 1995 · S/N 374-95N215BCMetzler Alan J · Reedsville, PABuilt 2005 · S/N 468-2005N216BCBell Wendell D · Littlerock, WABuilt 2007 · S/N 493-2007N21PZEarl'S Spray Service Inc · Breckenridge, MIBuilt 2000 · S/N 422-2000N221PMHester Thomas F · Boulder, UTBuilt 2004 · S/N 451-2003N225THMariner John M · Houston, TXBuilt 2010 · S/N 535-2010N22SXChase Jack L · Buxton, MEBuilt 2022 · S/N 626-2022N231PMBernard Raymond C · Melba, IDS/N 541-2011N233SFSale Reported · Wakarusa, INSale reportedBuilt 1999 · S/N 402-99N239LLLloyd Land Plane V LLC · Brighton, COBuilt 2021 · S/N 618-2021N23BDCox Mike Trustee · Casper, WYBuilt 2009 · S/N 517-2009N240SSStroup Robert L · New River, AZS/N 345-80N242BCElemental Aviation Lc · Wichita, KSBuilt 2011 · S/N 534-2010N247BCPlane Nutz LLC · Sugar City, IDBuilt 2011 · S/N 544-2011N249SFCasarez David W · Carmel Valley, CABuilt 2000 · S/N 418-2000N24SDHall Mike · Houston, TXBuilt 2022 · S/N 624-2022N2510ZCherry Hill Aviation Inc · Freetown, INBuilt 1977 · S/N 256-77N251WCThyssen Patrick L · Conroe, TXBuilt 2000 · S/N 424-2000N2547ZLecompte Francesca · Lancaster, MABuilt 1978 · S/N 261-78N2590ZWollaston Dean E · Hazel Green, WIBuilt 1977 · S/N 260-77N25GFNorth Dakota Game And Fish Dept · Bismarck, NDS/N 596-2019N2667ZHite Loren E · Fairbanks, AKBuilt 1978 · S/N 264-78N2682ZEmslie Donis A · West Lafayette, OHBuilt 1978 · S/N 265-78N2693ZCoen Brady · Wiley, COS/N 268-78
Back to AD 75-04-12