AD 2012-03-52

Registered aircraft · 522

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

N221VArea 52 Holdings Inc · Darlington, SCBuilt 2003 · S/N 29-0295N2220NDushek Matthew S · West Hartford, CTBuilt 2000 · S/N 29-0228N2228DAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2000 · S/N 29-0246N2228KSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2000 · S/N 29-0269N2229FMulligan Aviation LLC · Janesville, WIBuilt 2000 · S/N 29-0235N222GXBorchert Ronald L · Richfield, OHBuilt 2005 · S/N 29-0367N222JFCline Denis Jay Trustee · Colton, CABuilt 2004 · S/N 29-0331N222VSCharlie Rogers Ford Inc · Dayton, TNBuilt 2000 · S/N 29-0222N224GMVerboski Timothy W · Azle, TXBuilt 2015 · S/N 31-0137N233KTWelch Jackie L · Victoria, TXBuilt 2007 · S/N 31-0040N234WSMancini Gary Ray · Livermore, CABuilt 2004 · S/N 29-0343N237RBMed Ex LLC · Shiloh, ILBuilt 2007 · S/N 31-0025N237RPPohlner Roger E · Fisher, ARBuilt 2008 · S/N 31-0095N241KTRiley Robert V Jr · Hattiesburg, MSBuilt 2007 · S/N 31-0075N241SGFalasco Joseph R · Little Rock, ARBuilt 1999 · S/N 29-0196N242MDSpyder Flights LLC · Manchester, PABuilt 2003 · S/N 29-0292N242REAdvanced Avionics LLC · Cookeville, TNBuilt 2007 · S/N 31-0020N242TNBycroft Kathleen A Trustee · Salina, KSBuilt 2016 · S/N 31-0140N242WTMsm Enterprises LLC · Portland, ORBuilt 2008 · S/N 31-0105N246PCLna Flyer LLC · West Palm Beach, FLBuilt 1998 · S/N 29-0173N249SAGribble Ted A · Paris, TXBuilt 2001 · S/N 29-0267N251PCarolina Real Estate Consultants LLC · Pickens, SCS/N 29-0140N252MASbkb Aviation LLC · Henderson, NVBuilt 2006 · S/N 29-0425N257TMSunrise Aviation Group LLC · Kalispell, MTBuilt 2007 · S/N 31-0049N261JMHundal Medical Corp · Malibu, CABuilt 2007 · S/N 29-0475N267CTBachlechner Thomas Christian · San Diego, CABuilt 2007 · S/N 31-0050N26FFFastfun LLC · Fort Myers, FLBuilt 2004 · S/N 29-0352N26YValiair Lc Trustee · Casper, WYBuilt 2008 · S/N 31-0086N276CMTwo Fly Guys LLC · Orlando, FLBuilt 2006 · S/N 29-0445N278DBCt42 LLC · New York, NYS/N 29-0301N278SBKyle Benjamin LLC · Marriottsville, MDBuilt 2008 · S/N 31-0094N2811AAdrien Aviation LLC · Rochester, MIBuilt 2008 · S/N 29-0503N2820BChildress Kenneth W · Longview, TXBuilt 2008 · S/N 31-0099N288DMDavidson Christian · Auburn, WABuilt 2006 · S/N 29-0453N2903GMooney Wormtail Padfoot And Prongs LLC · Kalispell, MTBuilt 2008 · S/N 31-0123N299AGSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2000 · S/N 29-0252N299LG2 Huskies LLC · Sheridan, WYBuilt 2003 · S/N 29-0299N29EMIngram Earl · San Marcos, TXBuilt 2007 · S/N 29-0494N2ALAl Corporation · Wilmington, DEBuilt 1998 · S/N 29-0142N2SAInternational Air Services Inc Trustee · Carson City, NVBuilt 2005 · S/N 29-0376N300MESjk Aviation LLC · Orland Park, ILS/N 29-0479N31007M&E Air LLC · San Marcos, TXS/N 29-0277N311PDHaehnle Michael J · Milford, OHBuilt 1995 · S/N 29-0066N311TNB & B Aviation LLC · Evansville, INBuilt 2006 · S/N 31-0001N312DKline Robert H · Oley, PABuilt 2000 · S/N 29-0255N312TNUltimate Internet Access Inc · Wrightwood, CABuilt 2006 · S/N 31-0002N313TNSouthern Comfort Horizons LLC · Naples, FLBuilt 2006 · S/N 31-0003N316TNBfo Inc Trustee · Wilmington, DEBuilt 2007 · S/N 31-0013N321ELBecker Ronald G · Cresson, TXBuilt 1999 · S/N 29-0186N321FFInternational Air Services Inc Trustee · Carson City, NVBuilt 2008 · S/N 31-0120
Back to AD 2012-03-52