OpenAirDocs.org
AD 2017-06-13

Registered aircraft · 293

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:2017-06-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:2017-06-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.

N799MJElk Mountains Capital LLC · Newark, DEBuilt 2013 · S/N 680-0511N79BWilliam Becker LLC · Missoula, MTBuilt 2008 · S/N 680-0226N800RBRmb Aviation LLC · Bossier City, LABuilt 2005 · S/N 680-0030N807LPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 680-0326N80FWMedical Facilities Of America Inc · Roanoke, VAFirst renewal noticeBuilt 2008 · S/N 680-0238N811MBJetquest LLC · Greenville, SCBuilt 2007 · S/N 680-0156N817TVSovereign I LLC · Fishers, INBuilt 2008 · S/N 680-0213N818MFN818mf LLC · Austin, TXBuilt 2004 · S/N 680-0007N81NTHd Air LLC · Mercer, PAS/N 680-0305N824HHHilltop Holdings Inc · Dallas, TXBuilt 2011 · S/N 680-0310N827SMFh Aviation LLC · Collierville, TNBuilt 2011 · S/N 680-0316N830GGSmita 1212 LLC · Trumbull, CTBuilt 2008 · S/N 680-0200N838LJMcckc LLC · Bellevue, WABuilt 2006 · S/N 680-0074N865ECWrc Turtle Creek · Dallas, TXBuilt 2005 · S/N 680-0028N87EKEcj Bravo 2004 LLC · Wilmington, DEBuilt 2005 · S/N 680-0053N881EUBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 680-0223N883JABei Aviation LLC · Alpharetta, GABuilt 2014 · S/N 680-0517N884HJBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 680-0040N885JSSky Crossings II LLC · Charleston, SCBuilt 2013 · S/N 680-0508N888SFAerospace Holdings LLC · Lawrence, KSBuilt 2007 · S/N 680-0154N889DFStrain Aviation LLC · Abita Springs, LABuilt 2005 · S/N 680-0018N88JJSterling Motors Ltd · Newport Beach, CABuilt 2009 · S/N 680-0277N899JFBuildair LLC · Bridgehampton, NYBuilt 2007 · S/N 680-0122N900CMCharter Airplane Holding Company LLC · Mequon, WIBuilt 2019 · S/N 680-0591N907RPJwt Equipment LLC · Springdale, ARBuilt 2008 · S/N 680-0251N918EBBaccharis Capital LLC · Atherton, CABuilt 2012 · S/N 680-0343N927ACFamous Pawn Inc · Baltimore, MDBuilt 2008 · S/N 680-0202N927GMSjm Assets LLC · Houston, TXBuilt 2009 · S/N 680-0285N930MGGonsalves And Santucci Inc · Concord, CABuilt 2007 · S/N 680-0152N932JSEnola Gay LLC · Kinston, NCBuilt 2007 · S/N 680-0135N936JSPdia LLC · Austin, TXBuilt 2007 · S/N 680-0165N939CFMch Aviation LLC · San Antonio, TXBuilt 2006 · S/N 680-0056N942JSAltitude One Holdings LLC · Miami, FLBuilt 2005 · S/N 680-0033N943JSBhh Aviation LLC · Kinston, NCBuilt 2005 · S/N 680-0046N950JSN1jn-Sov LLC · Juno Beach, FLBuilt 2007 · S/N 680-0120N950SDSd Air LLC · Houston, TXBuilt 2005 · S/N 680-0042N956MBTih Aviation LLC · Dublin, GABuilt 2014 · S/N 680-0538N95TETec Equipment Inc · Portland, ORBuilt 2004 · S/N 680-0021N960HDGo Air LLC · Omaha, NEBuilt 2013 · S/N 680-0520N966JMLa Cadena Management LLC · Riverside, CABuilt 2005 · S/N 680-0027N96HEBravo Aviation LLC · Charlotte, NCBuilt 2011 · S/N 680-0315N977JHTextron Financial Corp · Wichita, KSBuilt 2020 · S/N 680-0592N99EFN504kh Holdings LLC · Wilmington, DEBuilt 2008 · S/N 680-0204
Back to AD 2017-06-13