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.

N197BLAm Aviation LLC · Boerne, TXBuilt 2008 · S/N 31-0097N197DTSzczerba Francis C · Cranberry Township, PABuilt 1997 · S/N 29-0113N197RMHjh Aviation LLC · Gordo, ALBuilt 2007 · S/N 29-0495N199MDSurgair Inc · Absarokee, MTBuilt 2003 · S/N 29-0298N2009FBowman And Dehn Enterprises Inc · Georgetown, DEBuilt 2016 · S/N 31-0143N200VPDrp Aviation LLC · Southlake, TXBuilt 2000 · S/N 29-0231N2011TEfferson Randal K · Lapine, ALBuilt 2016 · S/N 29-0524N201QPDesert Outdoor Advertising Inc · Bend, ORS/N 31-0005N2021MKunkel David L · Boulder, COBuilt 2015 · S/N 31-0138N204GXAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 29-0373N205BFWells David L · Neosho, MOBuilt 2005 · S/N 29-0386N205BZEmbedded Advantage LLC · Chelsea, MIBuilt 2005 · S/N 29-0411N207ARKanfei Harauch Air LLC · Cleburne, TXBuilt 2006 · S/N 31-0012N209HWWep Ent LLC · Graford, TXBuilt 2004 · S/N 29-0330N211MJKeefer Squared LLC · Rockmart, GABuilt 1994 · S/N 29-0019N211TSMartin Rolf Michael · Wellsburg, NYBuilt 2006 · S/N 29-0434N2120XGolberg Companies Inc · Garfield, MNBuilt 1996 · S/N 29-0103N2121SGreat Bay Aviation LLC · Spring Hill, FLBuilt 1997 · S/N 29-0106N2126SGarnet Ridge LLC · Brooksville, FLS/N 29-0133N212DMiller William K · Flat Rock, NCBuilt 2009 · S/N 31-0126N212TAJensen Paul · Exeter, NEBuilt 2005 · S/N 29-0392N2138ZPyle Richard B · El Paso, TXBuilt 1998 · S/N 29-0158N21434Ad-A-Note LLC · Tarentum, PABuilt 1998 · S/N 29-0159N2144PVanderhoof Brian L · Purcellville, VABuilt 1998 · S/N 29-0160N2145XMitchell Derrick · Winter Park, FLBuilt 1998 · S/N 29-0138N214DAFlight International Inc Trustee · Dover, DEBuilt 1999 · S/N 29-0181N214JSChavez Frederick J · Temecula, CABuilt 1997 · S/N 29-0128N2153KCaf Design LLC · Wilmington, DES/N 29-0115N2155ECavu Aviation LLC · Sugar Grove, ILBuilt 1998 · S/N 29-0165N2155KCurrent Obsession LLC · Gaylord, MIBuilt 1998 · S/N 29-0164N2157LAviation Medical Solutions Pllc · Mesa, AZS/N 29-0166N2158N2th Aviation LLC · Johnson City, TNBuilt 1998 · S/N 29-0167N2159ER & S Investment Partners LLC · Kennesaw, GABuilt 2000 · S/N 29-0238N2161SRegistration Pending · Montezuma, NMRegistration pendingBuilt 1998 · S/N 290137N21625Simpson Aaron J · Fort Smith, ARBuilt 1998 · S/N 29-0170N2164KSamojen Tony J · Camarillo, CABuilt 1998 · S/N 29-0172N216RAK&E Equipment LLC · Hammond, LABuilt 2008 · S/N 29-0519N21786Affinity Insurance Partners Inc DBA · Clearwater, FLBuilt 1999 · S/N 29-0194N2182HSpangler & Pion LLC · Davis, CABuilt 1996 · S/N 29-0095N2183ALee Christopher M · Port Jervis, NYBuilt 1999 · S/N 29-0198N21843Robertson James D Trutee · Mountain View, CABuilt 2000 · S/N 29-0220N2192JMcguire Robert · Hawthorne, FLBuilt 1999 · S/N 29-0206N2197HGprr Inc · Downers Grove, ILBuilt 1999 · S/N 29-0208N21KUAero Eagle One LLC · Kerrville, TXBuilt 1995 · S/N 29-0049N21MSVan Hanna Flying Circus LLC · Castle Rock, COBuilt 1999 · S/N 29-0197N2204LMccann Richard H · Shuqualak, MSBuilt 1999 · S/N 29-0209N2209MGarner Aviation LLC · Tampa, FLFirst renewal noticeBuilt 2000 · S/N 29-0237N2210YN2210y LLC · San Antonio, TXBuilt 2000 · S/N 29-0212N22166Reading Jared T · Uvalde, TXBuilt 2000 · S/N 29-0225N22184Rosene Richard W · Newport, RIBuilt 2000 · S/N 29-0227
Back to AD 2012-03-52