OpenAirDocs.org
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.

N120LWN120lw LLC · New York, NYBuilt 1998 · S/N 557N121SALove Wing Venture LLC · Agoura Hills, CABuilt 2001 · S/N 9082N1226Five Delta Alpha LLC · Dover, DEBuilt 2015 · S/N 9737N123EBTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 9167N123FTMirada Manager Gv LLC · Denver, COBuilt 1998 · S/N 549N1244Leon Global Express LLC · Miami, FLBuilt 2004 · S/N 9151N124GTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 9641N124STTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 9800N125CHPwcm Charter LLC · Highland Park, ILBuilt 2001 · S/N 9080N125GGSk Aviation Asset I LLC · Miami, FLBuilt 1997 · S/N 526N126EBElainebrown LLC · Anchorage, AKS/N 5327N126HRSeminole Tribe Of Florida · Hollywood, FLBuilt 2013 · S/N 5436N1271MGlobal Destinations LLC · Beaumont, TXBuilt 1998 · S/N 538N127CRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 5127N129AKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 9381N12MWDaggett Investment Corporation LLC · Teterboro, NJBuilt 2021 · S/N 196N130GVBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 630N132SD342 Ktcd LLC · Austin, TXBuilt 1998 · S/N 537N136FXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 5193N136QSRegistered aircraftBuilt 2025 · S/N 60182N137ZMZoma Falcon LLC · Centennial, COBuilt 2008 · S/N 9275N13999Zeit2019 LLC · Salt Lake City, UTBuilt 2014 · S/N 5494N1415NWilmington Trust Co Trustee · Wilmington, DEBuilt 2015 · S/N 6149N141QSRegistered aircraftBuilt 2012 · S/N 9479N142QSRegistered aircraftBuilt 2012 · S/N 9485N143MWMusic For The People Inc · Newton, MABuilt 2002 · S/N 9109N143QSRegistered aircraftBuilt 2012 · S/N 9499N145MGJlbml LLC · Atlanta, GABuilt 2003 · S/N 5004N145QSRegistered aircraftBuilt 2014 · S/N 9598N1461Bank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 5253N146ABBig Brie LLC · Wilmington, DEBuilt 2001 · S/N 9100N146QSRegistered aircraftBuilt 2014 · S/N 9615N147QSRegistered aircraftBuilt 2014 · S/N 9632N147SFAs Aviation III LLC · Knoxville, TNBuilt 2003 · S/N 5017N148QSRegistered aircraftBuilt 2014 · S/N 9648N149LPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 9019N150QSRegistered aircraftBuilt 2014 · S/N 9657N151QSRegistered aircraftBuilt 2015 · S/N 9730N152EZIssta Gs LLC · Dallas, TXBuilt 2002 · S/N 673N152PGAirish LLC · Orchard Lake, MIBuilt 1999 · S/N 9041N152QSRegistered aircraftBuilt 2016 · S/N 9773N154MHCinema Aircraft Executive Transportation LLC · Las Vegas, NVBuilt 1999 · S/N 592N154QSRegistered aircraftBuilt 2017 · S/N 9804N1556Metro Builders Supply Inc · Tulsa, OKBuilt 1998 · S/N 556N156QSRegistered aircraftBuilt 2018 · S/N 9856N157QSRegistered aircraftBuilt 2019 · S/N 9870N158Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 6307N159JAWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 6288N159WWWillas Wings LLC · Prescott, AZBuilt 1999 · S/N 578N160QSRegistered aircraftBuilt 2012 · S/N 9475
Back to AD 2013-05-13