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.

N426WULucy In The Sky LLC · Los Angeles, CABuilt 2005 · S/N 29-0340N426WWGolfdoc LLC · Kingman, AZBuilt 2006 · S/N 31-0007N428CMN428cm LLC · Indianapolis, INBuilt 2007 · S/N 31-0042N429PSMjk Leasing LLC · San Antonio, TXBuilt 2006 · S/N 29-0429N42MDN42md LLC · Ashburn, VABuilt 1999 · S/N 29-0178N42PJCapital Business Forms Inc · San Bernardino, CANon-citizen corporation, flight hours not reportedBuilt 2008 · S/N 31-0116N42TVK2 Aviation LLC · Carroll, IABuilt 1998 · S/N 29-0168N430GDrew Gorrie Photography LLC · Lawrenceville, GABuilt 2001 · S/N 29-0263N430TDHhc Aviation LLC · Melbourne, FLBuilt 2006 · S/N 29-0430N431DBDuininck Companies LLC · Prinsburg, MNBuilt 2003 · S/N 29-0288N431GXHb Acquisitions LLC · North Miami, FLBuilt 2006 · S/N 29-0431N431MJFlightera LLC · Richmond, KYBuilt 2007 · S/N 29-0491N436PSKramer James E · Nashville, TNBuilt 2007 · S/N 29-0490N437PAEsa Montana LLC · Helena, MTBuilt 2007 · S/N 31-0047N439SFCarter Randy C · Poway, CABuilt 1995 · S/N 29-0039N43FMBaseline Digital Inc · Satellite Beach, FLBuilt 1998 · S/N 29-0139N43HWPiper Nicholas W · Nanjemoy, MDBuilt 2000 · S/N 29-0259N4414BYoung Ronald R · Albuquerque, NMBuilt 2006 · S/N 31-0006N444ECOvation LLC · Wichita, KSBuilt 2006 · S/N 29-0467N444GNLandeis Keith · Mandan, NDBuilt 2015 · S/N 31-0139N444HKChurch David H · Albuquerque, NMBuilt 2003 · S/N 29-0312N446PCStatius-Muller Robert C Trustee · Stamford, CTBuilt 2006 · S/N 29-0446N448KMDecou Gordon C · Myakka City, FLBuilt 2015 · S/N 31-0134N44PZRegistered aircraftBuilt 1998 · S/N 29-0135N451USGreen Llp · Newport Beach, CABuilt 2006 · S/N 29-0437N452PSScuffletown LLC · Highlands, NJBuilt 2006 · S/N 29-0454N453MFSpain William D Jr · Mahopac, NYBuilt 1995 · S/N 29-0069N4545BTwist Air Inc · Overland Park, KSBuilt 2015 · S/N 29-0520N456GXBruschi Dale Alan · Hollywood, FLBuilt 2006 · S/N 29-0461N456PSGaston Trevino Jr · Brownsville, TXBuilt 2004 · S/N 29-0335N457DKMiller Gordon J Jr · Monaca, PABuilt 2003 · S/N 29-0313N4654MJetway LLC · Dover, DEBuilt 2005 · S/N 29-0370N467PSNeuwirth Robert · Gillette, WYBuilt 2007 · S/N 29-0481N468DABulk Transfer LLC · Horseshoe Bay, TXBuilt 2006 · S/N 29-0417N469MMMm Consulting Services · Fort Smith, ARS/N 29-0243N46BAArrington Investments Inc · Andrews, SCBuilt 1998 · S/N 29-0161N46DTEagle Ad-Venture LLC · Universal City, TXBuilt 2000 · S/N 29-0254N46WBBullen Riley P · Kingman, AZBuilt 2000 · S/N 29-0226N475RBN475rb LLC · Lexington, KYBuilt 1997 · S/N 29-0121N478PSTromp Enterprises LLC · Live Oak, TXBuilt 2007 · S/N 31-0027N484DMValiair Limited Co Trustee · Casper, WYS/N 31-0035N486PSMartin Jon R · Rayne, LABuilt 2007 · S/N 29-0486N489PSTorme Marvin R · Birmingham, ALBuilt 2007 · S/N 29-0489N490PSPeterson Nathan C · Cordova, TNBuilt 2007 · S/N 31-0032N493PSOn Target Aviation LLC · Albuquerque, NMBuilt 2007 · S/N 29-0493N495CPIris Fliers Inc · Fernandina Beach, FLBuilt 1995 · S/N 29-0058N496DEHegedus Bruce Alan · Anchorage, AKBuilt 1996 · S/N 29-0082N499RMSchell Robert W Trustee · Doylestown, PABuilt 2008 · S/N 29-0499N4YMBranches Aviation LLC · Lake Oswego, ORBuilt 2007 · S/N 31-0039N505WMAndrew Aircraft Sales LLC · Selmer, TNS/N 29-0151
Back to AD 2012-03-52