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.

N100PETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 680-0580N1010NScoular Co · Omaha, NEBuilt 2012 · S/N 680-0331N101EFEngineered Floors LLC · Dalton, GABuilt 2014 · S/N 680-0532N101FCL&B Air LLC · Northbrook, ILBuilt 2007 · S/N 680-0136N101PGPape Group Inc · Eugene, ORBuilt 2012 · S/N 680-0336N1027PTextron Aviation Inc · Wichita, KSBuilt 2004 · S/N 680-0004N105CDBjr Management LLC · Goldsboro, NCBuilt 2014 · S/N 680-0523N107DAAviation South LLC · South Lyon, MIBuilt 2006 · S/N 680-0063N110LEPlatinum Air LLC · Fort Worth, TXBuilt 2005 · S/N 680-0022N11GUSeamint LLC · Newton Grove, NCBuilt 2007 · S/N 680-0147N11UDAir Shamrock LLC · Fort Wayne, INS/N 680-0303N121JSJ R Simplot Company LLC · Boise, IDBuilt 2018 · S/N 680-0581N122PHPamplemousse Corp · Wilmington, DEBuilt 2010 · S/N 680-0294N128AJAvish Air LLC · Louisville, KYBuilt 2008 · S/N 6800218N12VURegistered aircraftBuilt 2014 · S/N 680-0531N147WRCore G Air LLC · Osteen, FLBuilt 2005 · S/N 680-0059N150TGHome Run LLC · Oakland, CABuilt 2007 · S/N 680-0127N151YDYellow Dart LLC · Warroad, MNBuilt 2008 · S/N 680-0197N153SGDfm III LLC · Cortland, NYBuilt 2006 · S/N 680-0101N156SWWhitney Group LLC · Larose, LABuilt 2010 · S/N 680-0296N15DPWalmart Inc · Bentonville, ARBuilt 2017 · S/N 680-0577N15LVPronto LLC · Oklahoma City, OKBuilt 2015 · S/N 680-0551N163RSummit Air LLC · Miami, FLBuilt 2007 · S/N 680-0163N165RCCbp Air Logistics LLC · Statham, GABuilt 2009 · S/N 680-0281N166HLPark Associates Inc · East Aurora, NYBuilt 2005 · S/N 680-0035N167SARegistration Pending · North Salt Lake, UTRegistration pendingBuilt 2005 · S/N 680-0043N168PXCitadel Aviation Investments LLC · Las Vegas, NVBuilt 2004 · S/N 680-0002N16CPWalmart Inc · Bentonville, ARBuilt 2016 · S/N 680-0567N178RHNci Group Inc · Cary, NCBuilt 2007 · S/N 680-0178N179PFRegistered aircraftBuilt 2017 · S/N 680-0574N17EJCore Air LLC · North Charleston, SCBuilt 2007 · S/N 680-0141N17ZPWalmart Inc · Bentonville, ARBuilt 2016 · S/N 680-0566N1866MPegasus IV LLC · Nashville, TNBuilt 2006 · S/N 680-0080N188TLBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 680-0257N18KWWcs Inc · Troy, ALBuilt 2011 · S/N 680-0323N18WELookout Air Inc · Marietta, GABuilt 2011 · S/N 680-0317N1930JJohnson & Johnson Aviation LLC · Wilmington, DEBuilt 2015 · S/N 680-0555N198SBCyppress Aviation LLC · Sellersburg, INBuilt 2004 · S/N 680-0020N19MKGp One LLC · Denver, COBuilt 2010 · S/N 680-0304N1PRPrm Corp · Pasadena, CABuilt 2013 · S/N 680-0340N1QEApf Development II LLC · Naples, FLBuilt 2006 · S/N 680-0067N1UACrimson Tide Foundation · Tuscaloosa, ALBuilt 2011 · S/N 680-0312N1ZCZachry Industrial Inc · San Antonio, TXBuilt 2006 · S/N 680-0085N200DZMax Aircraft LLC · Coraopolis, PABuilt 2008 · S/N 680-0243N203DNPti Air LLC · Tulsa, OKBuilt 2008 · S/N 680-0203N208MFCaledonia Leasing LLC · Mundelein, ILBuilt 2008 · S/N 680-0233N20HHubbard Broadcasting Inc · Saint Paul, MNBuilt 2012 · S/N 680-0338N20MKTrt Equity Advisors LLC · Dallas, TXBuilt 2017 · S/N 680-0573N211CCOrchard Aviation LLC · Birmingham, MIBuilt 2005 · S/N 680-0034N216STTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 680-0598
Back to AD 2017-06-13