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.

N615PXKempton Robert · Tampa, FLBuilt 2006 · S/N 29-0418N617DHChampionx LLC · Sugar Land, TXS/N 29-0518N618BLOrr Keith M Trustee · Portsmouth, NHBuilt 2009 · S/N 31-0127N627HPRobinson Elizabeth R · Malibu, CABuilt 2008 · S/N 31-0077N627PMRichardson David J Trustee · West Memphis, ARS/N 29-0332N62GHBas Part Sales LLC · Greeley, COBuilt 1999 · S/N 29-0190N62HWWestwind Holdings LLC · Wilmington, NCBuilt 2000 · S/N 29-0239N62TFLinares Rafael · Palatine, ILS/N 29-0188N632PAN632pa LLC · Debary, FLBuilt 2007 · S/N 31-0062N633GLRodine Dore N · Las Vegas, NVBuilt 2007 · S/N 31-0070N634MCPlane Fun Inc Tr Trustee · Snellville, GABuilt 2007 · S/N 29-0496N63LJLj Marshall Enterprises LLC · La Mesa, CABuilt 2008 · S/N 29-0515N63TJAir & Sea Travel Fantasies LLC · Rutherford, NJBuilt 2000 · S/N 29-0253N642CHPhoenix Leasing LLC · Menomonee Falls, WIBuilt 2006 · S/N 29-0457N646ACZimmers Herbert J · Fox Point, WIBuilt 1994 · S/N 29-0006N650DSFlight Crew Professionals LLC · Houston, TXBuilt 2001 · S/N 29-0276N654ADTrull Robert Scott · Austin, TXBuilt 2007 · S/N 31-0030N65PDVerhalen Flyers LLC · Marshall, TXBuilt 1995 · S/N 29-0052N660DSJsk Flight Service LLC · Dallas, TXBuilt 2006 · S/N 29-0415N665AGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2008 · S/N 31-0104N669WTLegacy Aviation LLC · Haddon Heights, NJBuilt 2007 · S/N 31-0041N676JMDpe Services Inc · Des Plaines, ILBuilt 2008 · S/N 31-0125N678JCJacs Adventures LLC · Conroe, TXBuilt 2006 · S/N 29-0463N6792GGrimmett Donna G · Tomball, TXS/N 29-0012N67GXDivision Of Aerodynamics LLC · Littleton, COBuilt 2005 · S/N 29-0344N6869LWeatherby Joseph III Trustee · Cuyahoga Falls, OHBuilt 2000 · S/N 29-0229N688MDDiamond Aero Corp · La Quinta, CABuilt 2007 · S/N 31-0017N694KTSzentkuti Richard · Ridgefield, CTBuilt 2004 · S/N 29-0329N698CMuehlstein Charles W · Stamford, TXBuilt 1999 · S/N 29-0205N698PM88west Jet Sales LLC · Wisconsin Rapids, WIBuilt 2008 · S/N 29-0504N6VWRegistered aircraftBuilt 1998 · S/N 29-0147N700RTLipton Jack · Cottonwood, AZBuilt 1996 · S/N 29-0097N705SEJones Hugh M · Locust Valley, NYBuilt 2008 · S/N 31-0117N708BCCc Liaison Corp Trustee · Wilmington, DEBuilt 2007 · S/N 31-0060N708PJKolasa Mark W · Washington, NCBuilt 2007 · S/N 31-0054N711WJBeaubien Philippe R · Houston, TXBuilt 2005 · S/N 29-0390N712NDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 29-0413N718PTTechnology Transportation Co Inc · La Crosse, WIBuilt 2003 · S/N 29-0294N71BFPlane Fun Inc Tr Trustee · Snellville, GAS/N 29-0412N721EMEuroaviation Inc Trustee · KematenBuilt 2007 · S/N 31-0064N721PGKelly Site Development LLC · Durham, NCS/N 29-0120N721WMSoftcomm Aviation Inc · Irvine, CABuilt 1995 · S/N 29-0023N722FMA/C Airwaves LLC · Seattle, WABuilt 1998 · S/N 29-0145N728VMGuthrie Group Inc · Summerfield, NCBuilt 2015 · S/N 31-0136N729MRFlanagan Brian F · Roseville, CAS/N 29-0017N72TFLeuthner Roger B · Albuquerque, NMBuilt 1999 · S/N 29-0195N730MLRomeo Juliet Whiskey LLC · Saint Louis, MOBuilt 2007 · S/N 31-0036N745DLLambert Thomas · Grand Junction, COBuilt 2008 · S/N 31-0114N750DBBearpack LLC · Boulder City, NVBuilt 2005 · S/N 29-0355N750DCHills Alan · Youngsville, NCBuilt 1997 · S/N 29-0123
Back to AD 2012-03-52