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.

N361QSRegistered aircraftBuilt 2008 · S/N 680-0235N363APBelden Inc · Chesterfield, MOBuilt 2006 · S/N 680-0095N369FGFulgent Genetics Inc · Temple City, CABuilt 2008 · S/N 680-0255N370MKc Investments LLC · Fargo, NDBuilt 2011 · S/N 680-0307N372QSRegistered aircraftBuilt 2008 · S/N 680-0201N376QSRegistered aircraftBuilt 2007 · S/N 680-0180N376RSIas Air LLC · Shelley, IDBuilt 2004 · S/N 680-0009N377TBGrove City Aviation LLC · Mercer, PABuilt 2008 · S/N 680-0187N387QSRegistered aircraftBuilt 2007 · S/N 680-0119N389QSRegistered aircraftBuilt 2007 · S/N 680-0149N396BBBrown & Brown Inc · Daytona Beach, FLBuilt 2007 · S/N 680-0123N396QSRegistered aircraftBuilt 2008 · S/N 680-0240N3TW3tw Aviation LLC · Austin, TXBuilt 2006 · S/N 680-0060N3ZCZachry Industrial Inc · San Antonio, TXBuilt 2012 · S/N 680-0346N401MWQuattro Air Ventures LLC · Houston, TXBuilt 2006 · S/N 680-0112N404SPDjd Aero LLC · Lubbock, TXBuilt 2005 · S/N 680-0039N405PVPauls Valley Aviation LLC · Norman, OKBuilt 2009 · S/N 680-0265N413CKAir Wolf LLC · Fremont, CABuilt 2006 · S/N 680-0064N417AMDb Air LLC · Houston, TXBuilt 2007 · S/N 680-0137N420DPPfe Aviation LLC · Mandeville, LABuilt 2012 · S/N 680-0322N422MLMvd Leasing LLC · Corona, CABuilt 2006 · S/N 680-0068N427GYG S D Rentals Inc · Norco, CABuilt 2015 · S/N 680-0542N428SSCurly Flyer LLC · Libertyville, ILBuilt 2005 · S/N 680-0041N447ECAngus Energy LLC · Dallas, TXBuilt 2006 · S/N 680-0098N448KCKinsley Construction LLC · York, PABuilt 2019 · S/N 680-0588N44SH44sh LLC · Oklahoma City, OKBuilt 2005 · S/N 680-0023N45AYTvpx Aircraft Solutios Inc · North Salt Lake, UTBuilt 2016 · S/N 680-0559N45JKAuto Force One LLC · Memphis, TNBuilt 2008 · S/N 680-0224N45NFNoble Research Institute LLC · Ardmore, OKBuilt 2016 · S/N 680-0556N461TAEastern Aviation Fuels Inc · New Bern, NCBuilt 2014 · S/N 680-0519N467VCouch Aviation Holdings LLC · Lexington, KYBuilt 2007 · S/N 680-0132N471CB888tn LLC · Collinsville, OKBuilt 2017 · S/N 680-0576N477BBJeta Mae LLC · Naples, FLBuilt 2007 · S/N 680-0138N483TWLandmark Sovereign Holdings LLC · Houston, TXBuilt 2007 · S/N 680-0143N497NMRegistration Pending · Mcdonough, GARegistration pendingBuilt 2014 · S/N 6800507N4ZCZachry Industrial Inc · San Antonio, TXBuilt 2006 · S/N 680-0077N503SVPerugia Air LLC · Dover, DEBuilt 2014 · S/N 680-0503N507GCCloudbound Logistics LLC · Columbus, MSBuilt 2008 · S/N 680-0239N511JFPhoenix Construction Services Inc · Lynn Haven, FLBuilt 2006 · S/N 680-0104N516CMTexas Air Machines LLC · Corpus Christi, TXBuilt 2015 · S/N 680-0549N516DBAshy M LLC · San Antonio, TXBuilt 2005 · S/N 680-0038N516PMV Aviation LLC · Overland Park, KSBuilt 2014 · S/N 6800529N51TETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 680-0572N521BUBridge Funding Group Inc · Hunt Valley, MDBuilt 2012 · S/N 680-0330N522JARx2 Partners LLC · Chester, VABuilt 2005 · S/N 680-0025N530KABank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 680-0595N531FCN50sq LLC · Lubbock, TXBuilt 2006 · S/N 680-0107N532SMSetzer Murry LLC · Lexington, KYBuilt 2005 · S/N 680-0017N5346MAlliance Laundry Systems LLC · Ripon, WIBuilt 2010 · S/N 680-0292N540PLWest End 65 LLC · Savannah, GABuilt 2020 · S/N 680-0594
Back to AD 2017-06-13