AD 2013-05-13

Registered aircraft · 1,167

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

N162JCSloan Harry Evans Trustee · Woodland Hills, CABuilt 1998 · S/N 539N162QSRegistered aircraftBuilt 2012 · S/N 9484N163EGC Dot Aviation LLC · Dover, DEBuilt 2000 · S/N 9069N163QSRegistered aircraftBuilt 2013 · S/N 9557N164QSRegistered aircraftBuilt 2014 · S/N 9649N165QSRegistered aircraftBuilt 2015 · S/N 9726N165VTMansfield Heliflight Inc · Milton, VTBuilt 2012 · S/N 9493N166AAE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1998 · S/N 548N166QSRegistered aircraftBuilt 2013 · S/N 9545N167QSRegistered aircraftBuilt 2015 · S/N 9689N167TVTeam Unicorn LLC · Hingham, MABuilt 2013 · S/N 5428N168CEInternational Aero Services LLC · Bellflower, CABuilt 1999 · S/N 568N168NWTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 6225N168PKPmc Global Inc · Sun Valley, CABuilt 1999 · S/N 579N168QSRegistered aircraftBuilt 2022 · S/N 60072N169QSRegistered aircraftBuilt 2024 · S/N 60157N169SDBank Of Utah Trustee · Salt Lake City, UTFirst renewal noticeBuilt 2013 · S/N 5455N16MFRegistered aircraftBuilt 2008 · S/N 5206N17018Bank Of Utah Trustee · Salt Lake City, UTS/N 6186N173NYBlf Aircraft Holdings LLC · Irvine, CABuilt 2007 · S/N 5149N175KHTvpx Trust Co LLC Trustee · North Salt Lake, UTS/N 9793N176SMBizav Support LLC · Fort Lauderdale, FLBuilt 2001 · S/N 637N1799CTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 5128N17FJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 607N17RXRxjet Transportation Services Corp · Oxford, CTBuilt 2016 · S/N 5548N180PETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 9783N1852VG200 LLC · San Juan, PRBuilt 2007 · S/N 5146N1875AUS Bank Na Trustee · Wilmington, DEBuilt 2016 · S/N 6248N1878EGalaxy Lift LLC · New York, NYBuilt 2008 · S/N 5187N188JHaut Enterprises LLC · North Kingstown, RIBuilt 2010 · S/N 9383N188WBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2017 · S/N 6263N18BNWorld Rep LLC · Toa Baja, PRBuilt 2012 · S/N 5402N18CJ18cj LLC · Norfolk, VAS/N 5245N18GNNair LLC · Purchase, NYBuilt 2008 · S/N 5180N18HInfinity & Beyond LLC · South Bend, INBuilt 2011 · S/N 5328N18NNSlj Acquisition LLC · Gainesville, FLBuilt 2006 · S/N 9185N18S5531 LLC · Seattle, WABuilt 2015 · S/N 5531N18TMAerownership North American Services Inc Trustee · Wilmington, DEBuilt 2001 · S/N 9090N18WZEwz Aviation Inc · Santa Monica, CABuilt 2009 · S/N 9338N1901GChevron U S A Inc · Sugar Land, TXBuilt 2017 · S/N 6257N190JAJacob Wing LLC · New York, NYBuilt 2008 · S/N 9274N1932PMozart Investments Inc · Roanoke, VABuilt 2016 · S/N 5549N1948ZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 600N194MFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1997 · S/N 510N1955QGmdair Corp · New York, NYBuilt 2014 · S/N 9645N1956MRegistered aircraftBuilt 2002 · S/N 675N1964MTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 5558N1967JEagle Mountain International Church Inc · Newark, TXBuilt 2000 · S/N 602N1989Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 9039N198RLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 5588
Back to AD 2013-05-13