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.

N219LDRocklyn Leasing LLC · Duluth, GABuilt 2005 · S/N 680-0032N21H21h Leasing LLC · Los Ranchos, NMBuilt 2012 · S/N 680-0335N221LCTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 680-0228N23NGNorthrop Grumman Systems Corp · El Segundo, CABuilt 2014 · S/N 680-0527N23SCTempest Aviation LLC · Dover, DEBuilt 2008 · S/N 680-0183N242ASGreenhaven Securities LLC · Concord, CABuilt 2006 · S/N 680-0084N250ATEnvironmental Specialties International Inc · Baton Rouge, LABuilt 2006 · S/N 680-0075N250CMHd Air LLC · Mercer, PABuilt 2007 · S/N 680-0170N253CPPriceflight LLC · Louisville, KYBuilt 2004 · S/N 680-0010N253TXJssi Parts LLC · Chicago, ILBuilt 2008 · S/N 680-0253N254MBSrb Africa Holdings LLC · Pasadena, TXBuilt 2012 · S/N 680-0341N259CAKansas LLC · Oklahoma City, OKBuilt 2014 · S/N 680-0505N259CKAcuity Aviation LLC · Atlanta, GABuilt 2009 · S/N 680-0278N261AHTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 680-0261N262SJSdjc Assets LLC · Houston, TXBuilt 2008 · S/N 680-0175N263TAPanorama Jets LLC · Dover, DEBuilt 2009 · S/N 680-0263N271PHMeridian Continuum LLC · Fort Lauderdale, FLBuilt 2007 · S/N 680-0151N27DDDiamond D Aviation LLC · Sulphur, LABuilt 2009 · S/N 680-0267N284JSbsw22 LLC · Newark, DEBuilt 2006 · S/N 680-0105N288HKTranscendent Investments LLC · Wilsonville, ORBuilt 2011 · S/N 680-0313N289KRTroy Equipment Holdings LLC · Houston, TXBuilt 2008 · S/N 6800193N29AGNutrien Ag Solutions Inc · Loveland, COBuilt 2006 · S/N 680-0100N2LPMmxii LLC · Chesapeake, VABuilt 2008 · S/N 680-0219N2QAir Sansone LLC · Wilmington, DEBuilt 2005 · S/N 680-0051N2QGFlagship Private Air LLC · Jackson, MIBuilt 2008 · S/N 680-0231N300HLCx4people Inc · Irvine, CABuilt 2009 · S/N 680-0286N300JCRegistered aircraftBuilt 2021 · S/N 680-0597N303TPPti Air LLC · Tulsa, OKBuilt 2008 · S/N 680-0203N307LSCombined Aircraft Ownership LLC · Fargo, NDS/N 680-0066N308LJNspiration Aviation LLC · Menlo Park, CABuilt 2006 · S/N 680-0109N308QSRegistered aircraftBuilt 2006 · S/N 680-0116N3099Bank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2010 · S/N 680-0306N30GNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 680-0570N310BNBcwings LLC · Hartland, WIBuilt 2013 · S/N 6800516N313QSRegistered aircraftBuilt 2007 · S/N 680-0140N315QSRegistered aircraftBuilt 2008 · S/N 680-0220N317QSRegistered aircraftBuilt 2007 · S/N 680-0160N320HBHb Equipment Co LLC · Wildwood, FLBuilt 2008 · S/N 680-0188N320QSRegistered aircraftBuilt 2007 · S/N 680-0169N323QSRegistered aircraftBuilt 2007 · S/N 680-0134N324QSRegistered aircraftBuilt 2008 · S/N 680-0242N333KGTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2008 · S/N 680-0189N333MGMam Development LLC · Abingdon, VABuilt 2012 · S/N 680-0332N334QSRegistered aircraftBuilt 2007 · S/N 680-0164N339BConcord Jet Service Inc · Concord, CABuilt 2005 · S/N 680-0058N339QSRegistered aircraftBuilt 2008 · S/N 680-0191N341QSRegistered aircraftS/N 680-0225N356WABank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 680-0512N357QSRegistered aircraftBuilt 2007 · S/N 680-0155N359QSRegistered aircraftBuilt 2007 · S/N 680-0126
Back to AD 2017-06-13