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.

N755BWSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2007 · S/N 29-0476N767BKF&E G A Inc · Miami Springs, FLBuilt 2005 · S/N 29-0377N767SBRegistered aircraftBuilt 2005 · S/N 29-0383N772PACassity Scott · Las Vegas, NVBuilt 2008 · S/N 31-0112N772PCThompson John Christopher · Dallas, TXBuilt 2005 · S/N 29-0402N7734MHeinrich Bruce · East Burke, VTBuilt 2005 · S/N 29-0397N773VAndy Petree Inc · Denver, NCS/N 29-0265N7758JLeaman Gary R · Alpine, WYS/N 31-0068N7772LJerez John J · Bonita, CABuilt 1996 · S/N 29-0093N777XMDenton Lake Ltd · Port Charlotte, FLBuilt 2007 · S/N 29-0482N77GJSees Aviation Inc Trustee · CheltenhamBuilt 2005 · S/N 29-0356N77PHRiddick Aviation LLC · Columbia, MOBuilt 2000 · S/N 29-0234N781TCKeystone Ridge LLC · Colorado Springs, COBuilt 2006 · S/N 310014N781WBCopley Square Air LLC · Weston, MABuilt 2008 · S/N 31-0085N782JBRibaudo Janice · Los Angeles, CABuilt 2008 · S/N 31-0082N783SYKrajewski Richard · North Sutton, NHBuilt 2000 · S/N 29-0247N78PEFun Aviation LLC · Rockford, MIBuilt 2008 · S/N 290506N792RCRegistered aircraftBuilt 2006 · S/N 29-0439N79333Blue Moon Navigation Inc · Austin, TXBuilt 2008 · S/N 31-0121N79336Yaggie Allen · Wahpeton, NDBuilt 2005 · S/N 29-0379N79339Wetzel Matthew DBA · Round Mountain, TXBuilt 1998 · S/N 29-0171N795PJWarren John B · Port Jefferson, NYBuilt 2006 · S/N 29-0472N79FMWoods Executive Services Inc · Mineola, TXBuilt 1999 · S/N 29-0179N79SMTurbine Services And Consulting LLC · Bedford, TXBuilt 1995 · S/N 29-0028N800DD2826 LLC · Inola, OKBuilt 1995 · S/N 29-0024N805PMColwell Blue Berry Farm LLC · Ellsworth, MEBuilt 2005 · S/N 29-0391N807PJPhillips David T · Warsaw, NCBuilt 2008 · S/N 29-0512N808WMCarney Adam S · Middletown, NJBuilt 1995 · S/N 29-0072N809PAHardy David · Fairview, MTBuilt 2008 · S/N 31-0109N80HWSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1999 · S/N 29-0207N811TSManagement Programs Corp · Vero Beach, FLBuilt 2006 · S/N 29-0420N812PTAngel Ventures LLC · Natchez, MSBuilt 2007 · S/N 31-0061N815TLee D Trotter Do Pc · Rapid City, SDS/N 31-0022N816LMKobylar Lester J · Greensboro, GABuilt 2000 · S/N 29-0250N81FMSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1999 · S/N 29-0180N823AFAerosset LLC · San Juan, PRBuilt 2006 · S/N 29-0432N826JSBranson Chad F · Asheboro, NCBuilt 2008 · S/N 29-0513N828BPHot Wings Aviation Ltd · Wilmington, DEBuilt 2005 · S/N 29-0399N82CGLincoln David C · Henderson, NVBuilt 2015 · S/N 31-0130N831TAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1995 · S/N 29-0031N83RJMckenzie Aviation Corp · Port Orange, FLS/N 29-0185N843LGPapa Mike LLC · Dover, DEBuilt 2000 · S/N 29-0219N871TXNlmds Leasing LLC · Tierra Verde, FLBuilt 2006 · S/N 29-0449N872PALima Delta Co Trustee · New Castle, DES/N 31-0072N87FAAircraft Partner Holdings Inc Trustee · BerlinBuilt 2008 · S/N 29-0514N888KNBaker Tim Young · Lafayette, LABuilt 2006 · S/N 29-0468N888REDill Harry H Trustee · Mebane, NCBuilt 2003 · S/N 29-0291N890RDSengle Gregory R · Amherst, MAFirst renewal noticeBuilt 1996 · S/N 29-0089N892PSKahoe Timothy P · Charlotte, NCBuilt 2008 · S/N 31-0092N898PJBaucum Jeffrey P · Sequim, WABuilt 1997 · S/N 29-0109
Back to AD 2012-03-52